insert into 表名(name,gender...)values("张三",“男”...) 具体增加字段,values内容是
删:delete
delete from 表名 where where后面加删除的的条件
比如
delete from users where id = 6 id=1的删除
delete from users where id = 6 and gender = 0
delete from users where id = 6 or gender = 0
delete from users where id > 6
delete from users where id in (4, 5)