Mysql很重要的相关知识

ALTER TABLE person RENAME tb_person;

ALTER TABLE tb_person DROP bornDate;

ALTER TABLE tb_person ADD bornDate DATE;

ALTER TABLE tb_person CHANGE number id BIGINT NOT NULL;

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

INSERT INTO student(loginPWD,studentName,sex,gradeID,phone,address,bornDate,email,identityCard)
	VALUES('123','郭靖','男',1,'13645667783','天津市河西区','1990-09-08','guojing@qq.com','410000'),
	('123','李文才','男',1,'13645667783','天津市河西区','1990-09-08','liwencai@qq.com','400000'),
	('123&#