[lua, mysql] 将多条记录数据组合成一条sql插入语句(for mysql)
摘要:-- 演示将多条记录数据组合成一条sql插入语句(for mysql)function getTpl0(tname) -- 获取表各个字段 local t = { tpl_pack = {"packId","itemId","`group`","num","rate","rateType"}, ...
阅读全文
posted @
2015-07-26 10:17
清清飞扬
阅读(1745)
推荐(0) 编辑
实现mysql按月统计的教程
摘要:From: http://www.jbxue.com/db/758.html实现mysql按月统计的教程mysql有个字段是DATETIME类型,要实现可以按月统计,该怎么写sql语句?select month(f1) from tt group by month(f1)or select DATE...
阅读全文
posted @
2015-07-10 22:56
清清飞扬
阅读(14682)
推荐(1) 编辑
MySQL的varchar长度问题
摘要:From: http://blog.csdn.net/longyulu/article/details/7863737http://dinglin.iteye.com/blog/914276http://www.cnblogs.com/fakis/archive/2011/03/07/1976532...
阅读全文
posted @
2015-07-09 17:54
清清飞扬
阅读(19235)
推荐(0) 编辑