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