这次面试比较特殊,给了试卷,让直接口头回答,说实话,挺喜欢这样的。 最后一道是数据库题,表如下自己YY了初始化语句mysql> create table fmatch( mdate date, team varchar(20),res enum(WIN,LOSE) );mysql> insert into fmatch values(2010-10-19,76ers,WIN); Query OK, 1 row affected (0.07 sec)mysql> insert into fmatch values(2010-10-20,76ers,LOSE); Query OK, 1 row affected (0.07 sec)mysql> insert into fmatch va...
2.测试数据 select * from student ;insert into student(name,subject,score) values(‘张‘,‘语文‘,96) ; insert into student(name,subject,score) values(‘张‘,‘数学‘,62) ; insert into student(name,subject,score) values(‘张‘,‘英语‘,85) ; insert into student(name,subject,score) values(‘王‘,‘语文‘,12) ; insert into student(name,subject,score) values(‘王‘,‘英语‘,100) ; insert into student...