mysql操作语句 

1.一条语句查多个字段逗号隔开
SELECT ItemList,MoneyList,MailID from mail WHERE RoleGUID=10000139
2.倒叙查询结果
SELECT ItemList,MoneyList,MailID from mail WHERE RoleGUID=10000139 order by MailID desc
3.lua 语句
local sqlText = string.format( "UPDATE mail SET MoneyList = %s ItemList = %s", BaseFuc.serialize(MoneyList),BaseFuc.serialize(ItemList),bIsCheck,nMailID) 
4.查询满足条件的数量
select count(*) from mail where RecvRoleName = 'byf'


 

posted @ 2013-05-24 09:31  byfei  阅读(152)  评论(0)  编辑  收藏  举报