代碼如下：use student;
?CREATE TABLE student(
studentno VARCHAR(10) NOT NULL PRIMARY KEY,
studentname VARCHAR(20) NOT NULL,
loginpwd VARCHAR(8) NOT NULL,
sex CHAR(1) ,
majorid INT NOT NULL REFERENCES grade(majorid),
phone VARCHAR(11),
email VARCHAR(20) ,
borndate DATETIME
);
CREATE TABLE major(
majorid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
majorname VARCHAR(20) NOT NULL
);
CREATE TABLE result(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
studentno VARCHAR(10) NOT NULL REFERENCES student(studentno),
score DOUBLE
);
INSERT INTO major VALUES(NULL,'javaee');
INSERT INTO major VALUES(NULL,'html5');
INSERT INTO major VALUES(NULL,'android');
INSERT INTO student VALUES('S001','張三封','8888','男',1,'13288886666','[email protected]','1966-9-1');
INSERT INTO student VALUES('S002','殷天正','8888','男',1,'13888881234','[email protected]','1976-9-2');
INSERT INTO student VALUES('S003','周伯通','8888','男',2,'13288886666','[email protected]','1986-9-3');
INSERT INTO student VALUES('S004','張翠山','8888','男',1,'13288886666',NULL,'1995-9-4');
INSERT INTO student VALUES('S005','小小張','8888','女',3,'13288885678','[email protected]','1990-9-5');
INSERT INTO student VALUES('S006','張無忌','8888','男',2,'13288886666','[email protected]','1998-8-9');
INSERT INTO student VALUES('S007','趙敏','0000','女',1,'13288880987','[email protected]','1998-6-9');
INSERT INTO student VALUES('S008','周芷若','6666','女',1,'13288883456','[email protected]','1996-7-9');
INSERT INTO student VALUES('S009','殷素素','8888','女',1,'13288886666','[email protected]','1986-1-9');
INSERT INTO student VALUES('S010','宋遠橋','6666','男',3,'1328888890','[email protected]','1996-2-9');
INSERT INTO student VALUES('S011','楊不悔','6666','女',2,'13288882345',NULL,'1995-9-9');
INSERT INTO student VALUES('S012','楊逍','9999','男',1,'13288885432',NULL,'1976-9-9');
INSERT INTO student VALUES('S013','紀曉芙','9999','女',3,'13288888765',NULL,'1976-9-9');
INSERT INTO student VALUES('S014','謝遜','9999','男',1,'13288882211',NULL,'1946-9-9');
INSERT INTO student VALUES('S015','宋青書','9999','男',3,'13288889900',NULL,'1976-6-8');
INSERT INTO result VALUES(NULL,'s001',100);
INSERT INTO result VALUES(NULL,'s002',90);
INSERT INTO result VALUES(NULL,'s003',80);
INSERT INTO result VALUES(NULL,'s004',70);
INSERT INTO result VALUES(NULL,'s005',60);
INSERT INTO result VALUES(NULL,'s006',50);
INSERT INTO result VALUES(NULL,'s006',40);
INSERT INTO result VALUES(NULL,'s005',95);
INSERT INTO result VALUES(NULL,'s006',88);
uj5u.com熱心網友回復：
請問應該怎么解決呢 多謝多謝轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/256065.html
標籤：MySQL
上一篇：mysql 卸載了，資料庫沒有備份使用data恢復一直報錯有大神知道怎么操作嗎
下一篇：mysql 創建存盤程序，求指教