操作表中的数据 上机练习2

**

操作表中的数据 上机练习2

**
需要的代码如下，数据在表中插入

/*USE student

CREATE DATABASE studentinfo
USE studentinfo;
CREATE TABLE stuinfo (id INT(5) auto_increment PRIMARY KEY, name  VARCHAR(20),classroom VARCHAR(20) ,age VARCHAR(10),sex VARCHAR(20),room VARCHAR(20)      )
SELECT * FROM stuinfo
CREATE TABLE SUBJECT (SUBJECTid INT(5) auto_increment PRIMARY KEY, SUBJECTname  VARCHAR(20),credithour VARCHAR(20) ,credit VARCHAR(10),creditid VARCHAR(20)     )
CREATE TABLE Teacher (Teacherid INT(10) auto_increment PRIMARY KEY, Teachername  VARCHAR(20),Gender VARCHAR(20) ,Graduateschool VARCHAR(10),Major VARCHAR(20),Education VARCHAR(20),GradeuateTime VARCHAR(20),TeacherTime VARCHAR(20) ,DepartmentID VARCHAR(20)      )

*/
SELECT * FROM teacher