PHP重点知识数据库SQL语句学习.docxVIP

《PHP重点------数据库知识》--创建数据库 schoolcreate database school--删除数据库drop database schoolgo--可以派出先后执行顺序--更改当前操纵的数据库use schoolgo--创建教师表--主表create table teacher(class_namevarchar(20)primary key,tea_namevarchar(20)not null,t_timedatetimedefault(getdate()))go--创建学生表--从表create table student(stu_idintidentity(1,1)primary key,stu_namevarchar(20)not null,sexchar(2)check(sex=男 or sex=女),scoreintdefault(0),class_namevarchar(20)foreign key references teacher(class_name)--class_name字段必须是teacher表的主键)go--添加语句insertinsert into teacher(class_name,tea_name)values(s123,张老师)insert into teacher values(s456,郭老师,2008-1-2 1