一、增 在某表添加一行:
- 只插入行中某些列:
insert into class
<name,gender,salary>
value
<'枫耀',‘男’,8765.43>; - 插入行中所有列:
insert into class
values
<'枫耀',‘男’,'22',8765.43>; - 同时插入多行:
insert into class
<name ,gender ,salary>
values
<'刘备',‘皇室成员’,15.28>
<‘孙策’,‘江东集团’,‘56.34’>
<‘曹操’,‘宦官后裔’,‘10.12’>
二、改 更新某表的某列
- update class
set gender=‘男’ ,fanbu='212'
where id =6;
三、删 删除某表的某行数据
- delete from class
where salary>8800; - delete from class
where salary>8000 and gender='女';
四、查 查找哪个表的哪些列
- select name,company,salary
from class
where id=6; - 暴力查找class表的全部:
select * from class; - select * from class
where id>3;