"MySQL Getting started is simple" exercise 6.6

(1) First create the database school

(2) Create a teacher table

Select Database

(3) Change the data type of the name field of the teacher table to varchar (30)

(4) Change the position of the birthday field to the front of the sex field

(5) Rename num field to t_id

MySQL can be empty by default, and if you change the field name, the default value is null if you do not write the integrity constraint.

(6) Delete the Address field of the teacher table

(7) Add a field named wages to the teacher table with a data type of float

(8) Renaming the teacher table to Teacherinfo

(9) Change the storage engine of the Teacherinfo table to the MyISAM type

(1) Create Department tables and worker tables under the example database

(2) Delete Department table

"MySQL Getting started is simple" exercise 6.6