create table student
(
zkzh char(20) not null primary key,
name char(8) not null,
major char(20) null,
birth date not null,
sex tinyint(1) not null default 1,
score tinyint(1) null,
address char(60) not null,
phone char(11) not null,
picture longblob null,
note text null
);

(
zkzh char(20) not null primary key,
name char(8) not null,
major char(20) null,
birth date not null,
sex tinyint(1) not null default 1,
score tinyint(1) null,
address char(60) not null,
phone char(11) not null,
picture longblob null,
note text null
);