Mysql的常用语句

1-- 创建表
2create table tableName(
3    id int primary key,
4   name varchar(20)
5)
6
7-- 查询
8select * from tableName
9
10-- 查询并排序(降序，升序是asc)
11select * from tableName order by desc 
12
13-- 分组查询 (根据姓名分组)
14select name,count(*) from tableName group by name
15
16-- 分组查询 (根据姓名分组) 分组后再查询 
17select name,count(*) from tableName group by name having name = "张三"
18
19-- 模糊查询 查询姓名中含有张的
20select * from tableName where name like '%张%'
21
22-- 修改
23update tableName set name = ? where id = ?
24
25--删除
26delete from tableName-- 分页查询select * from tableName limit 0,10