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');
本文地址：http://com.8s8s.com/it/it26300.htm