全部博文(413)
发布时间:2014-07-03 14:21:09
http://www.mysqlperformanceblog.com/2010/06/15/what-does-handler_read_rnd-mean/MySQL’s SHOW STATUS command has two counters that are often confusing and result in “what does that mean?” questions:Handler_read_rndHandler_read_rnd_nextAs I understand it, there.........【阅读全文】
发布时间:2014-06-17 17:15:26
项目中一条语句:点击(此处)折叠或打开SELECT role_goods.id,role_goods.number,roleId,role.`name` ,goods.`name` as '物品名称'from role_goodsLEFT JOIN role on role.id =role_goods.roleId LEFT JOIN goods on goods.id=role_goods.goodsId.........【阅读全文】
发布时间:2014-04-08 00:55:10
DELIMITER //DROP PROCEDURE IF EXISTS mingRenTangJiangLi //CREATE PROCEDURE mingRenTangJiangLi()BEGINDECLARE total_level,role_id,ming_ren_level,ming_ren_type, fuben_times,tiaozhan_times,duobei_shijian,no_more_data INT DEF.........【阅读全文】
发布时间:2014-03-31 21:38:52
下面的sql语句报错:sql错误 (1221) :Incorrect usage of union and order byselect * from guojia_jingjia where guanzhi='xxx' order by (aaa+bbb+ccc) desc limit 1 union select * from guojia_jingjia where guanzhi in (...) order by bbb desc limit 4 union select * from guojia_jingjia where guanzhi in .........【阅读全文】