mysql查询
浊浊然
这个作者很懒,什么都没留下…
展开
-
MYSQL 查询所有父级id
SELECT T2.FID FROM ( SELECT @r AS _id, (SELECT @r := FParentID FROM t_module_checkin_class WHERE FID = _id) AS FParentID, @l := @l + 1 AS lvl FROM (SELECT @r := 6, @l := 0) vars, t_module_checkin_clas原创 2014-07-25 14:06:16 · 456 阅读 · 0 评论 -
mysql获取数据表的信息语句
获取所有表信息 show table status; 获取某一个表信息 show table status where name="table_name"; SHOW 指令(‘[..]’里的可选) 显示mysql中所有数据库的名称 show databases; 显示mysql中的相关表 show tables [ from db_name] 查看存储过程状态 show procedure s原创 2014-07-25 14:05:36 · 223 阅读 · 0 评论 -
mysql 随机查询
SELECT * FROM `table` WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`)) + (SELECT MIN(id) FROM `table`))) ORDER BY id LIMIT 1; SELECT * FROM `原创 2014-07-25 14:04:42 · 183 阅读 · 0 评论 -
mysql 关联数据迁移
UPDATE tn ,(SELECT xx,,GROUP_CONCAT(ID) id FROM tb GROUP BY xID) ta SET tn.xxx=id WHERE ta.xx=tn.xx ; 多数据到一字段原创 2014-07-25 14:06:10 · 176 阅读 · 0 评论