简单MySQL 语句

USE spring;/*drop table if exists Employee;*/CREATE TABLE Employee (id INT  PRIMARY KEY AUTO_INCREMENT,email VARCHAR(200),dept_id INT);SHOW TABLES FROM spring;SELECT * FROM Employee;ALTER TABLE Employee ADD NAME VARCHAR(36) AFTER id;INSERT INTO employee(email,dept_id) VALUE("[e-mail]",2);UPDATE Employee SET NAME  = "ly" WHERE id = 2;/* *更新多个字段 */UPDATE Employee SET NAME="Mary",email="[e-mail]" WHERE id = 3;UPDATE Employee SET NAME  = "lucy" WHERE email="[e-mail]";UPDATE Employee SET email = "[e-mail]" WHERE id = 1;DELETE FROM Employee WHERE id  = 16;DELETE FROM Employee WHERE id > 4 AND id < 15;DELETE FROM Employee WHERE NAME = "CC";