1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| create table t_stu(id int,name varchar(10),age int);
1. 插入数据
-全表插入:要求插入的数据的数量和顺序要和表字段的数量顺序一致,格式:insert into 表名 values(值1,值2,值3....);
insert into t_stu values(1,'zhangsan',23);
-指定字段插入格式:insert into 表名 (字段1,字段2...) values(值1,值2...);
insert into t_stu (id,name) values(2,'lisi');
-批量插入:
insert into t_stu values(3,'悟空',23),(4,'八戒',20),(5,'沙僧',18);
insert into t_stu (id,name) values(6,'刘备'),(7,'关羽'),(8,'貂蝉');
2. 查询数据
select * from t_stu;
select name,age from t_stu;
3. 删除数据
delete from t_stu where name='八戒';
delete from t_stu where age is null;
4. 修改数据
update t_stu set name='张三' where id=1;
update t_stu set name='卷帘大将',age=200 where id=5;
|