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 “深圳“, year date
);
insert into teacher values('''''''',''''glchang'''',''''深圳一中'''',''''1988-12-10'''');
insert into teacher values('''''''',''''wangfei'''',''''枣庄三中'''',''''1977-12-10'''');