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