mysql中添加数据库

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');