记mysql一些简单命令

查询

-- select * from users
-- select username, password from users
-- select * from users where status=1
-- select * from users where id>=2
-- select * from users where id>=2 and status=0
-- select * from users where id<2 or status=1
-- select * from users order by id asc
-- select * from users order by id desc
-- select * from users order by status desc, username asc

计数查询

-- select count(*) from users where status=1

别名查询

-- select count(*) as total from users
-- select password as 密码 from users

插入数据

insert into users (username, userspassword) values ('1223','asde')

更新数据

-- update users set password='123111' where id='4'
-- update users set password='123111',status='1' where id='4'

删除数据

delete from users where id='8'