你可能感兴趣的试题
UPDATE SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩'WHERE sname='张明'
第(38)~(40)题基于学生一课程数据库中的3个基本表:
学生信息表:s(sno,sname,sex,age,dept)主码为sno
课程信息表:c(cno,cname,teacher)主码为cno
学生选课信息表:sc(sno,cno,grade)主码为(sno,cno)
UPDATE SET sname='小明' WHERE sname='小强' UPDATE student SET sname='小明' WHERE sname='小强' UPDATE student SET sname='小强' UPDATE student SET sname='小强' WHERE sname='小明'
SELECT * FROM student WHERE sname LIKE'刘 * ' SELECT * FROM student WHERE sname LIKE'刘 $' SELECT * FROM student WHERE sname LIKE'刘%' SELECT * FROM student WHERE sname LIKE'刘&'
UPDATE SET sname='张明'WHERE sname='张岩' UPDATE student SET sname='张明'WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩'WHERE sname='张明'
UPDATE SET sname='张明'WHERE sname='张岩' UPDATE student SET sname='张明' WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩' WHERE sname='张明'
UPDATE SET sname='张明'WHERE sname='张岩' UPDATE student SET sname='张明'WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩'WHERE sname='张明'
UPDATE SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname:'张明'WHERE sname='张岩' UPDATE student SET sname='张岩' UPDATE student SET sname='张岩'WHERE sname='张明' 第(38)~(40)题基于学生一课程数据库中的3个基本表: 学生信息表:s(sno,sname,sex,age,dep主码为sno 课程信息表:c(cno,cname,teache主码为cno 学生选课信息表:sc(sno,cno,grad主码为(sno,cn