DROP DATABASE IF EXISTS School;
Create Database School;
Use School;
CREATE TABLE TEACHER
(
ID INT (3) Auto_Increment Not Null Primary Key,
Name char (10) Not null,
Address varchar (50) Default "Shenzhen",
Year Date
);
INSERT INTO TEACHER VALUES ('', 'Glchang', 'Shenzhen No.1 Middle ",' 1988-12-10 ');
INSERT INTO TEACHER VALUES ('', 'Wangfei', 'Zaozhuang Third ",' 1977-12-10 ');
