1. 插入数据
创建数据表:
create table students (
stu_num char(8) primary key,
stu_name varchar(20) not null ,
stu_gender char(2),
stu_age int ,
stu_tel char(11) not null ,
stu_qq varchar(11)
)
插入数据语法:
insert into <tableName> (column1,column2...) values (value1,value2...);
数据表后的字段名列表顺序可以与表中不一致,但是values中值的顺序必须和表名后字段顺序对应
insert into students (stu_num,stu_name,stu_tel) values ('20211212','张三','13501011100');
向表中所有列添加数据时,数据表名后面的字段列表可以省略,values中值的顺序要和数据表定义字段顺序一致
insert into students values ('20211213','李四','男',25,'13500000001','123456')
注:实际项目中,向所有列添加数据,建议将列名都显示写出来,增强SQL的稳定性。
insert into students (stu_num,stu_name,stu_gender,stu_age,stu_tel,stu_qq) values ('20211214','王五','男',25,'13500000002','123456')
2. 修改数据
对数据表中已经添加的数据进行修改
语法
updata <tableName> set <column> = value where 条件
#同时修改姓名和手机号
update students set stu_name = '小白',stu_tel = '13999999999' where stu_num = '20211212';
#不加where条件,修改表中该列所有数据
update students set stu_name = '小黑',stu_tel = '13999999998'
3. 删除数据
从数据表中删除满足条件的记录
语法:
delete from <tableName> where 条件
# 删除students表中stu_age大于20的数据
delete from students where stu_age > 20
#删除students数据表中的所有数据
delete from students