案例 mysql

CREATE TABLE department01(
	id INT,
	dep_name VARCHAR(20),
	dep_id VARCHAR(20)
);
ALTER TABLE department01 CHANGE dep_id dep_location VARCHAR(20);

CREATE TABLE employee01(
	id INT,
	NAME VARCHAR(20),
	age INT,
	dep_id INT
);
ALTER TABLE employee01 MODIFY id INT PRIMARY KEY;
ALTER TABLE employee01 MODIFY id  INT AUTO_INCREMENT;  -- 要先设置主键再设置自增长
INSERT INTO employee01 VALUES(NULL,'张三',20,1);


DELETE FROM department01 ;-- 删除department01里面的内容但是表格留着
ALTER TABLE department01 MODIFY id INT PRIMARY KEY  AUTO_INCREMENT ;
INSERT INTO department01(id,dep_name,dep_location)VALUES(NULL,'研发部','广州'),(NULL,'销售部','深圳');
SELECT*FROM department01;

DELETE FROM department01 WHERE id=4;
ALTER TABLE employee01 ADD CONSTRAINT dept_emp_fk FOREIGN KEY (dep_id) REFERENCES department01(id) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE employee01 DROP FOREIGN KEY dept_emp_fk;`department01``employee01``employee01``employee01``department01`