mysql数据操作

1.增

insert into 表名（列名，列名) vlues (值，值), (值，值), (值，值), (值，值);

insert into app01_prettyNum(mobile,price,level,status)
values('18045399999',99,1,1);

2.删

delete from 表名；
delete from 表名 where 条件 ;
delete from tb7;
delete from tb7 where id = 3;
delete from tb7 where id = 4 and name="谢涛";
delete from tb7 where id = 4 or name="谢涛";
delete from tb7 where id > 4;
delete from tb7 where id >= 4;
delete from tb7 where id != 4;
delete from tb7 where id in (1,5);

3.改

update 表名 set 列=值;
update 表名 set 列=值，列=值，列=值；
update 表名 set 列=值 where 条件;

4.查

select * from 表名;
select 列名，列名 from 表名;
select 列名称,列名称 from 表名称 where 条件;

select * from tb7;
select id,name from tb7;
select id,name from tb7 where id > 10;
select id,name from tb7 where name="xx" and password="xx";