createtable myclass(
id INT(11)primarykeyauto_increment,
name varchar(20)unique);createtable student (
id INT(11)primarykeyauto_increment,
name varchar(20)unique,
passwd varchar(15)notnull,
classid INT(11),constraint stu_classid_FK foreignkey(classid)references myclass(id));