lab.sql

1, lab.sql为为数据库代码

create database lab;

use lab;

create table student
(
id int primary key auto_increment,
number char(10),
name char(20),
sex char(4),
birthday char(10),
dnum char(20),
college char(20),
classes char(10),
connection char(20)
);
create table checktion
(
id int primary key auto_increment,
sno char(10),
cname char(20),
lname char(20),
checktion char(10)
);