全部博文（413）
发布时间：2014-08-13 20:47:25
oracle数据库想mysql数据库迁移时，遇到了一个oracle函数: instr(str, '|', pos), 在字符串str中pos的位置开始，查找字符'|'，如果存在，则返回其位置。而mysql中有函数instr只有两个参数：instr(str, substr)。于是自动动手写了个函数来代替：点击(此处)折叠或打开DELIMITER $$.........【阅读全文】
发布时间：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.........【阅读全文】
