studentmanager.sql

来自「它统一管理各个应用系统用户的身份验证」· SQL 代码 · 共 22 行

--database name:student    user:root  password:123
drop table studentInfo;
create table studentInfo(
	id numeric(4) primary key,
	name nvarchar(20) not null,
	phone numeric(20),
	mobile numeric(20),
	address nvarchar(60),
	email nvarchar(40),
	qq numeric(15)
);

insert into studentInfo values(0002,'tiger',26668468,13920600000,'ssdut','[e-mail]',417322876);
insert into studentInfo values(0010,'jim',26681111,13920612345,'ssdut','[e-mail]',1453543);
insert into studentInfo values(0003,'tom',26668468,13920600000,'ssdut','[e-mail]',5434532);
insert into studentInfo values(0004,'jimmy',26668400,13920600123,'ssdut','[e-mail]',5342354);
insert into studentInfo values(0005,'scofield',26668468,139206008900,'ssdut','[e-mail]',453325);
insert into studentInfo values(0006,'scott',26668468,13920600023,'ssdut','[e-mail]',54353);
insert into studentInfo values(0007,'tiger',26668468,13920612000,'ssdut','[e-mail]',453254);
insert into studentInfo values(0008,'marry',26668468,13920608900,'ssdut','[e-mail]',45332);
insert into studentInfo values(0009,'vigoss',26668468,13920645670,'ssdut','[e-mail]',54325);
insert into studentInfo values(0001,'lucifer',26668888,1392060011,'ssdut','[e-mail]',54342);