mysql操作语句

获取某个表中的最大序号数，使用select max（id） from table
select * from role_data where role_name LIKE "%查询我";
一条语句查多个字段逗号隔开
SELECT ItemList,MoneyList,MailID from mail WHERE RoleGUID=10000139
倒叙查询结果
SELECT ItemList,MoneyList,MailID from mail WHERE RoleGUID=10000139 order by MailID desc
lua 语句
local sqlText = string.format( "UPDATE mail SET MoneyList = %s ItemList = %s",strMoneyList,strItemList,bIsCheck,nMailID)
查询满足条件的数量
select count(*) from mail where RecvRoleName = 'byf'
更多语句使用：
http://www.w3school.com.cn/sql/sql_orderby.asp