create table student ( snum varchar(20) not null, sname varchar(20) not null, ssex varchar(20) not null, sclass varchar(20) not null, semail varchar(30), sbirthday date, shouseaddress varchar(20) );
表中输入信息
insert into studentvalues (1,'111','男',1,'10086@xx.com',to_date('1970-06-06','yyyy-mm-dd'),'沈阳');