如何用mysql或mssql语句建如下表格？

MYSQL语句为：
create database test;
use test;
create table classinfo(classid int primary key, classname varchar(20),primary key (classid) );
insert into classinfo values (1, '1班');
insert into classinfo values (2, '2班');
insert into classinfo values (3, '3班');
create table stuinfo(stdid varchar(20),classid int,stuname varchar(20),stusex varchar(2),studirth datetime,stuaddress varchar(200), primary key (stuid));
insert into stuinfo value('1-1',1,'甲','男','2009-1-1','黄泉路');
insert into stuinfo value('1-2',1,'乙','男','2009-1-1','黄泉路');
insert into stuinfo value('1-3',1,'丙','男','2009-1-1','黄泉路');

其实可以交互式点鼠标输入，无需语句。