SELECT查询语句

匹配语句：SELECT * FROM `test` WHERE `uid` LIKE '%张%'
分组语句：SELECT * FROM `test` group by `remark`
排序语句：SELECT * FROM `test` order by `id` asc/desc
指针查询：SELECT * FROM `test` limit 0,2
统计函数：SELECT count(*) FROM `test` WHERE 1
最大值函数：SELECT MAX(id) FROM `test` WHERE 1
最小值函数：SELECT MIN(id) FROM `test` WHERE 1
平均值函数：
累计值函数：
Insert 插入语句：insert into test(`id`,`uid`,`regdate`,`remark`) values('9','宋相坤',now(),'学生')
Update 更新语句：UPDATE test set uid='包青天' where id='6'
Delete 删除语句：DELETE FROM test WHERE id=6