[手游新项目历程]-43-sql关键字解决

sql关键字解决
update charge_list set `Result`=1 where `Order` = '123456abc';
local sqlText = string.format("UPDATE charge_list SET `Result`=%d WHERE `Order` = '%s'", 1, tostring(Order))

select "NUMBER" from tablename where "NUMBER" = '11'
在后台写时要这么写,必须是要双引号，而且关键字必须大写
"select \"NUMBER\" from tablename where \"NUMBER\" = '11' "