MySQL第三章高级查询上机1-8

MySQL第三章高级查询

#上机—练习1
创建数据表,并实现对表的修改操作
CREATE TABLE person(
number INT(4) AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NULL,
sex CHAR(2),
bornData DATETIME
)

#修改表名
ALTER TABLE person RENAME tb_person;
#删除
ALTER TABLE tb_person DROP bornData;
#添加
ALTER TABLE tb_person ADD bormDate DATE;
#修改
ALTER TABLE tb_person CHANGE number id BIGINT;

#上机—练习二

ALTER TABLE result ADD CONSTRAINT fk_result_student FOREIGN KEY(studentNo) REFERENCES student(studentNo);

#上机–练习上
#成绩表
INSERT INTO result VALUES
(10000,1,‘2016-02-15’,71),
(10000,1,‘2016-02-17’,60),
(10001,1,‘2016-02-17’,46),
(10002,1,‘2016-02-17’,83),
(10003,1,‘2016-02-17’,65),
(1