1 CREATE database schoolInfo;//首先创建数据库schoolInfo 2 3 use schoolInfo;//使用数据库schoolInfo 4 5 CREATE TABLE teacherInfo( //创建teacherInfobiao 6 id INT(4) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT, 7 num INT(10) NOT NULL UNIQUE, 8 Name VARCHAR(20) NOT NULL, 9 Sex VARCHAR(4) NOT NULL, 10 Birthday DATETIME, 11 Address VARCHAR(50) 12 ); 13 14 ALTER TABLE teacherInfo MODIFY name VARCHAR(30) NOT NULL;//将teacherInfo的表name字段 15 16 的数据类型改为BAECHAR（30） 17 18 ALTER TABLE teacherInfo MODIFY birthday DATETIME AFTER name;//将birthday字段的位置改 19 20 到sex字段的前面 21 22 ALTER TABLE teacherInfo CHANGE mumtid INT(10) NOT NULL;//将num字段名改为t_id 23 24 ALTER TABLE teacherInfo DROPaddress;//将teacherInfo表的address字段删除 25 26 ALTER TABLE teacherInfo ADD wasges FLOAT;//在teacherInfo表中增加名为wages的字段，数 27 28 据类型为FLOAT 29 30 ALTER TABLE teacherInfo RENAME teacherInfo lnfo;//将teacherInfo表改名为teacherInfo 31 32 Info 33 34 ALTER TABLE teacherInfo ENGINE = MyISAM;//将teacherInfo表的存储引擎更改为MyISAM