mysql表增删查改常用sql语句

--插入数据 insert
insert into `table_name` ( `column01_name` , `column02_name` , ... ) values ( value01 , value02 ,  ...)

--查询数据 select
select * from `table_name` where `column01` = value01 and `column02` = value02 and ...

--修改数据 update
update `table_name` set `column01_name` = new_value01 , `column02_name` = new_value02 , ...

--删除数据 delete
delete from `table_name` where `column01_name` = value01 , `column02_name` = value02 ,