简单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("lucy@gmail.com",2);


UPDATE Employee SET NAME  = "ly" WHERE id = 2;
/*
 *更新多个字段
 */
UPDATE Employee SET NAME="Mary",email="mary@hotmail.com" WHERE id = 3;


UPDATE Employee SET NAME  = "lucy" WHERE email="lucy@gmail.com";

UPDATE Employee SET email = "test@qq.com" WHERE id = 1;


DELETE FROM Employee WHERE id  = 16;


DELETE FROM Employee WHERE id > 4 AND id < 15;


DELETE FROM Employee WHERE NAME = "CC";