create database UserManagement;
use UserManagement
create table users
(
id int Not null primary key,
username Varchar(30) Not null,
email Varchar(30) Not null,
grade int Not null,
password Varchar(30) not null
);
insert into users values(1,'mantantan','mantantan@163.com',0,'mt123');
insert into users values(2,'fancahotong','fancahotong@163.com',1,'mt123');
insert into users values(3,'Mary','Mary@163.com',1,'mt123');
insert into users values(4,'Jone','Jone@163.com',1,'mt123');
insert into users values(5,'Stone','Stone@163.com',1,'mt123');
insert into users values(6,'Pthoe','Pthoe@163.com',1,'mt123');
insert into users values(7,'Jay','Jay@163.com',1,'mt123');
insert into users values(8,'Dee','Dee@163.com',1,'mt123');
insert into users values(9,'Waer','Waer@163.com',1,'mt123');