下面将视图view_stu中字段chinese值更新为100的语句中,正确的是()
A: UPDATE
view_stu SET chinese = 100;
B: ALTER
view_stu SET chinese = 100;
C: UPDATE
VIEW view_stu SET chinese = 100;
D: ALTER
VIEW view_stu SET chinese = 100;
A: UPDATE
view_stu SET chinese = 100;
B: ALTER
view_stu SET chinese = 100;
C: UPDATE
VIEW view_stu SET chinese = 100;
D: ALTER
VIEW view_stu SET 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;
- 下面将视图view_stu中字段chinese值更新为100的语句中，正确的是
- 下面（）语句是用来修改已经创建好的视图的 A: alter table B: update…set… C: create view D: alter view
- 以下创建视图的语句中,正确的是 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
- 下面将视图view_goods中商品名为“迷彩帽”的gdPrice值更新为30的语句中，正确的是（）。 A: alter view view_goods set gdprice=30 where gdname='迷彩帽'; B: alter view_goods set gdprice=30where gdname='迷彩帽'; C: update view_goods set gdprice=30where gdname='迷彩帽'; D: update view view_goods set gdprice=30where gdname='迷彩帽';