insert.sql

学生选课系统无数据库

insert into Students(studentUID,username,studentgender,studentage,dept,studentCode,studentclass) values ('01','小南','M','20','Math','0601','三班');

insert into Students(studentUID,username,studentgender,studentage,dept,studentCode,studentclass) values ('02','莉莉','F','20','Computer','0603',''四班');

insert into Students(studentUID,username,studentgender,studentage,dept,studenCode,studentclass) values ('03','加加','M','20','English','0634','四班');




insert into Lib (username,usergender,age,user,password) values ('mo','M','20','root','mo');



insert into Techer (name,,age,tech,user,password) values ('wangrong','F','35','Computer','Computer','wangrong');

insert into Techer (name,sex,age,tech,user,password) values ('zhangli','F','35','Math','Math','zhangli');

insert into Techer (name,sex,age,tech,user,password) values ('xiaoli','F','35','English','English','xiaoli');