MySQL第三天笔记+作业

笔记1，

1、增加1>insert into 表名 values(值列表);
2>create table 表名 as select.... 数据表不存在，语句执行后会创建
3>insert into 表名 select ....:插入表中字段必须和查询的字段保持一致

INSERT INTO employee VALUES(NULL,'C',DEFAULT,'1997-9-6','113',NULL);
INSERT INTO employee(empname,empbirth,empphone) VALUES('D',NOW(),'114');
INSERT INTO employee VALUES(NULL,'E','男','1998-9-9','112',2),(NULL,'F','男','1998-9-9','112',2);

CREATE TABLE emp_bak AS SELECT * FROM employee;
CREATE TABLE emp_bak2 AS SELECT empid,empname,empsex FROM employee;

INSERT INTO employee2 SELECT * FROM employee;
INSERT INTO employee2(empname,empsex) SELECT empname,empsex FROM employee;

2、修改update 表名 set 列=值,列=值 .... where 条件

UPDATE employee SET empname='张三丰' WHERE empid=1;
UPDATE employee SET empname='张三丰',empphone='118' WHERE empid=1;

3、1>删除 delete from 表名 where 条件