进阶14_约束_作业
ALTER TABLE emp2 MODIFY COLUMN id INT PRIMARY KEY;
ALTER TABLE emp2 ADD CONSTRAINT my_emp_id PRIMARY KEY(id);
ALTER TABLE emp2 ADD COLUMN dept_id INT;
ALTER TABLE emp2 ADD CONSTRAINT fk_emp2_dept2 FOREIGN KEY(dept_id) REFERENCES dept2(id);
进阶16-15_事物+视图_作业
CREATE TABLE test(
id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
stuname VARCHAR(20) UNIQUE,
seat VARCHAR(20)
);
SET autocommit=0;
SHOW VARIABLES LIKE 'autocommit'
START TRANSACTION
INSERT INTO test VALUES(1,'张三','1号')
INSERT INTO test VALUES(2,'李四','2号'</