mysql实例练习(国外英语资料).doc

mysql实例练习(国外英语资料) Definition of the sutdent table Field name, field description, data type, primary key, foreign key, non empty, unique, self increasing Id student number INT (10) Yes, yes, yes Name name VARCHAR (20) no, no, yes or no Sex sex VARCHAR (4) no, no no no no Birth year of birth, YEAR no, no, no, No. Department Department VARCHAR (20) whether or not yes or no? Address home address VARCHAR (50) no, no, no, no, no Definition of the score table Field name, field description, data type, primary key, foreign key, non empty, unique, self increasing Id number INT (10) is yes, yes, yes Stu_id student number INT (10) no, no, yes or no C_name course name VARCHAR (20), no, no, no, no, No. Grade scores INT (10) no, no, no, no, No. Create student table CREATE, TABLE, student ID, INT, unsigned, PRIMARY, KEY, AUTO_INCREMENT, Name VARCHAR (20) NOT NULL, Sex VARCHAR (4), Birth YEAR, Department VARCHAR (20), Address VARCHAR (50) ); Create score table CREATE, TABLE, score ID, INT, unsigned, PRIMARY, KEY, AUTO_INCREMENT, Stu_id, INT, unsigned, NOT, NULL, C_name VARCHAR (20), Grade INT unsigned ); Load data to the student table: INSERT INTO student VALUES (901, Zhang boss, male , 1985 , computer department , Beijing, Haidian District ), (902, Zhang Lao, male, 1986, Chinese Department, Beijing, Changping District), (903, ` Zhang three , female , 1990, Chinese Department, Hunan, Yongzhou), (904, Li four, male, 1990, English Department, Liaoning, Fuxin), (905, ` king five , female , 1991, English Department, Fujian, Xiamen), (906, ` king six , male , 1988 , computer department , Hunan, Hengyang ); Load data to the score table: INSERT INTO score VALUES (NULL, 901, computer, 98), (NULL, 901, English, 80), (NULL, 902, computer, 65), (NULL, 902, ` Chinese , 88), (NULL, 903, ` Chinese , 95), (NULL, 904, computer, 70), (NULL, 904, English, 92), (NULL, 905, English, 94), (NULL, 906, computer, 90), (NULL, 906, English, 85); 3. query all records of the student table 4. query the student