SQL语句

查询语句

SELECT * FROM blade_menu WHERE `name`='商城管理'

查询两个条件

SELECT * FROM base_table_extend WHERE table_name='merCar' AND modulename=''

按顺序排列

SELECT * FROM base_table_extend WHERE table_name='merCar' AND modulename='oilTankTruck' ORDER BY ordered

更改信息

-- 改为已审核
update natural_escort_gl set AUDIT_FLAG = '1' where id = '1529303076449480706'

-- 改为未审核
update natural_escort_gl set AUDIT_FLAG = '0' where id = '1529303076449480706'

模糊查询

SELECT * FROM natural_escort_gl WHERE id LIKE '%1529303076449480706%'