在建立好的 student 表中插入数据信息,在查询分析器中编辑如下命令:
insert into student values('001101','宋大方','男','19','计算机')
insert into student values('002102','李王','男','20','信息')
insert into student values('991101','张彬','男','18','计算机')
insert into student values('991102','王蕾','女','19','计算机')
insert into student values('991103','张建国','男','18','计算机')
insert into student values('991104','李平方','男','18','计算机')
insert into student values('991201','陈东辉','男','19','计算机')
insert into student values('991202','葛鹏','男','21','计算机')
insert into student values('991203','潘桃芝','女','19','计算机')
insert into student values('991204','姚一峰','男','18','计算机')
insert into student values('001102','许辉','女','22','计算机')
insert into student values('001201','王一山','男','20','计算机')
insert into student values('001202','牛莉','女','19','计算机')
insert into student values('002101','李丽丽','女','19','信息')
运行后,再刷新表,打开表,看到刚建好的学生表如下: