- SQL:结构化查询语言
- DB:datebase 数据库
SQL语句主要有三个部分构成:DDL DML DCL
一、DDL:数据定义语言
二、DML:数据操作语言
(insert delete update select)
1、添加数据 insert
insert into stu values("001","zhangsan","man",20);
insert into stu(id,name, sex) values("002","lisi","woman");
//当添加数据与字段个数不匹配则要注明添加数据所对应的字段
小批量添加数据时,数据与数据中间加 “ ,”
insert into stu values("002","wangwu","man",22),
("003","zhaosi","man",21);
2、删除数据 delete
delete from stu;
//所有数据都满足,即全部删除
delete from stu where id ="004";
//where加过滤条件,只删除id=004的数据
3、修改数据 update
updeta stu set sex = "man"