4.表数据的增删改查—重重点
a)增加数据/插入数据/新增数据
i. 一条数据
1.insert into [tb name](字段名1,字段名2,字段名n)
values(值1,值2,值n);
例:【
desc s_info;查看信息
insert into s_info(sno,sname,sbirch,ssex)values
(1,'fbb','20000101','f');//添加信息
select * from s_info;//查看信息
】
ii.多条数据
lnsert into [tb name](字段名1,字段名2,字段名n)values
(值1,值2,值n),
(值1,值2,值n),
(值1,值2,值n);
例:【
insert into s_info(sno,sname,sbirch,ssex)values
(1,'zzx','1998-1-1','m'),
(2,'wxw','1998-2-2','m'),
(3,'wyb','1998-3-3','m'),
(4,'ch','1998-4-4','m'),
(5,'sr','1998-5-5','m'),
(6,'hqy','1998-6-6','m'),
(7,'zcc','1998-7-7','m');
select * from s_info;
】
iii.给特定字段新增数据
insert into [tb name](字段名1,字段名n)values
(值1,值n);
例:【
insert into s_info(sno,sname)values
(8,'lsq');
select * from s_info;
】
b)查询数据
i.查询所有数据
select * from [tb name];
例:select * from s_info;
ii.**查询部分数据**
select * from [tb name] where sno=5;
例:select * from s_info where sno=5;
c)**更改数据**
i.修改指定数据[按条件修改]
update [tb name] set sbirth='2000-1-1'
where sno=5;
例:update s_info set sbirth='2000-1-1'
where sno=1;
ii.修改所有数据
update [tb name] set sbirth='2000-1-1'
例:update s_info set sbirth='2000-1-1'
d)**删除数据**
i.删除所有数据
1.delete from [tb_name];
2.truncate table [tb_name];【慎用】
ii.删除限定数据
delete from [tb_name]where sno=5;
例:delete from s_info where sno=9;