插入数据
格式:insert into 表名(字段1,字段2,..字段n)values(值1,值2,..值n);
1.在指定的字段插入数据
例如:insert into member(id,regname,pwd) values(1,'jury','123456');
2.默认在所有字段插入数据(不指定具体字段)
例如:insert into member values(1,'mary','123456','13652412512');
3.同时插入多条记录
例如:insert into member values(2,'yary','122532','13528552233'),
(3,'kary','125856','13822212512'),
(4,'wary','178956','13965447852');
4.指定某些字段同时插入多条数据
例如:insert into member(regname,mobliephone) values('suner1','18262415262'),
('suner2','18595857454'),
('suner3','15895412121');
删除数据
格式:delete from 表名 where 子句;
1.删除整张表的所有数据
例如:delete from member;
2.条件删除(根据满足的条件删除)
例如1:delete from member where id=1;(单个条件删除)
例如2:delete from member where id=1 and id=3;(多个条件and)
例如3:delete from member where regname='sunyy1' or regname='sunyy2';(多个条件or)
3.删除全部记录,再插入数据不会恢复自增长id的初始值
①delete from member;(member表中有10条数据,全部被删除)
②再在member表中插入数据,id从11开始自增
4.删除全部记录,再插入数据恢复自增长id的初始值为1
①truncate table member;