mysql 创建表实例
create database school;// 建立库schooluse school;// 打开库SCHOOL
create table teacher(// 建立表TEACHER
> name char(10) not null,
address varchar(50) ,
year date
);// 建表结束
// 以下为插入字段
insert into teacher values(”,’allweeeen’,'河南一中’,'1976-10-10′);
insert into teacher values(”,’jwcsdddk’,'河南二中’,'1975-12-23′);
页:
[1]