MySQL数据库常用指令

1.查询users表中的所有数据，所有字段

select * from users;

2.像列表中插入数据 

insert into users (username,password) values ('钢铁侠','adc123');
select * from users;

3. 修改指定条件字段

update users set password="888888",status=0 where id=3; 
select * from users;  

4.删除指定条件数据 

delete from users where id=4;
select * from users;

5.where 子句,或者条件语句(查询，删除，修改)

 select * from users where id=2;
 select * from users where id!=2;

6.AND和OR 运算符 

 update users set status=1 where id=2; 
 select * from users where id<3 and status=1;
 select * from users where status=1 or username='wangwu';

7.order by排序： asc升序（默认），desc：降序

 select * from users order by status asc;
 select * from users order by status desc;

8. 查询总条数

select count(*) from users where status=0;
select count(*) as total from users where status=0;