31 lines
546 B
SQL
31 lines
546 B
SQL
-- 请根据下方提示，在正确位置填写代码或脚本。
|
||
.header on.mode column
|
||
/********** Begin *********/
|
||
-- 将tina同学的专业更新为“math”
|
||
update
|
||
reader
|
||
set
|
||
major = "math"
|
||
where
|
||
name = "tina";
|
||
|
||
/********** End *********/
|
||
select
|
||
*
|
||
from
|
||
reader;
|
||
|
||
/********** Begin *********/
|
||
--查询专业为“science”的学生信息，将science专业的学生的年龄统一增加1岁。
|
||
update
|
||
reader
|
||
set
|
||
age = age + 1
|
||
where
|
||
major = "science";
|
||
|
||
/********** End *********/
|
||
select
|
||
*
|
||
from
|
||
reader; |