下面将视图view_stu中字段chinese值更新为100的语句中,正确的是
举一反三
- 下面将视图view_stu中字段chinese值更新为100的语句中,正确的是
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;
- 视图定义如下:CREATE VIEW view_stu2(math,chin,sum) AS SELECT math,chinese,math+chinese FROM student;下面选项中,能够正确使用视图的语句是
- 创建视图stu的语句为:CREATE VIEW ss AS【1】* FROM s_view WHERE score>=60
- 以下创建视图的语句中,正确的是 A: CREATE st_view AS SELECT sid,sname,ssex FROM stu B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu C: CREATE VIEW st_view AS sid,sname,ssex FROM stu D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu