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'


 

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/byfei/p/3112095.html