Mysql

查询

查询所有内容

• select * from user where 1

查询某个用户

• select * from user where name=‘zeng8’ and password=‘zmm123’

查询分数大于500的

• select * from user where score>500

查询所有用户（从1开始，截取2条）

• select * from user where 1 limit 1,2

查询所有用户（按分数排序，升序acs，降序desc）

• select * from user where 1 order by score acs
• select * from user where 1 order by score desc

查询两个字段

• select name,score from user where 1

"_"代表任意一个字符

• select * from user where name like ‘zeng_’

"%"代表一个或多个字符

• select * from user where name like ‘zeng%’

增加

• insert into user (name,password,score)
  values (‘zeng11’,‘zmm123’,120)
• values (‘zeng11’,md(‘zmm123’),120);//密码加密

修改

把zeng8的分数改为2500

• update user set score=2500 where name=‘zeng8’

把zeng_的分数改为2500，'_'代表任意字符

• update user set score=2500 where name like ‘zeng_’

删除

删除user中id为5的行

• delete from user where id=5