mysql 创建表记录

// 创建库
create database shero default charset utf8;

// 使用库
use shero;

// 创建表
create table student
(
id integer not null,
stuname varchar(20) not null,
stusex bit default 1,
stubirth datetime not null,
stutel char(11),
stuaddr varchar(255),
stuphoto longblob,
primary key (id)
);

insert into student values 
(1005, '丘处机', 1, '1983-5-5','63527772', '北京市海淀区宝盛北里西区28号', null),
(1006, '王处一', 1, '1985-6-6', '63527772','深圳市宝安区宝安大道5010号', null),
(1007, '刘处玄', 1, '1987-7-7','63527772', '郑州市金水区纬五路21号', null),
(1008, '孙不二', 0, '1989-8-8','63527772', '武汉市光谷大道61号', null),
(1009, '平一指', 1, '1992-9-9','63527772', '西安市雁塔区高新六路52号', null),
(1010, '老不死', 1, '1993-10-10','63527772', '广州市天河区元岗路310号', null),
(1011, '王大锤', 0, '1994-11-11','63527772', null, null),
(1012, '隔壁老王', 1, '1995-12-12','63527772', null, null),
(1013, '郭啸天', 1, '1977-10-25', '63527772',null, null);