2021-01-29

–students 表中同时添加多行数据
INSERT INTO students2 VALUES (“cyan”,21,“男”,1,“2000-01-01”);–报错，id虽然是自增，但是同时增加多行数据时会报错

INSERT INTO students2 VALUES ("1"“cyan”,21,“男”,1,“2000-01-01”);

–students 表中添加name,gender 两个字段的数据
INSERT INTO students2 (NAME ,cls_id) VALUES (“哈哈”,2);
INSERT INTO students2 (NAME , genger ,cls_id )VALUES(“上善若水”,3,1);
–students 表中同时添加多行数据
INSERT INTO students2 (NAME ,gender ) VALUES (“欢喜”,2),(“乌龟”,3);
–将姓名全部修改为jack
UPDATE students2 SET NAME=jack;
–查询students2 表中name 与gender 字段的数据
SELECT NAME,gender FROM students2;
–查询指定字段重命名

SELECT NAME AS “姓名”,gender AS “性别” FROM students2 ;
–给表进行重命名
SELECT a.name FROM students2 AS a ;

–where子句
–查询id 大于3的数据
SELECT FROM students2 WHERE id>3;