A: ALTER TABLE user set age=55;
B: UPDATE user set age=55 where age=55;
C: UPDATE user set age=55;
D: UPDATE user set age=55 where age<=55;
举一反三
- 下面选项中,能够更新user表中数据的SQL语句是() A: update into user set id = 'u001'; B: update user set id = 'u001' and username='jack'; C: update user set username='jack' where id = 1; D: update into user set id = 'u001', username='jack';
- 控制台修改表USER,往表中增加一个整形非空字段AGE的语句正确的是( )。 A: ALTER TABLE USER ADD AGE INT NOT NULL B: DROP TABLE USER C: CREATE TABLE IF NOT EXISTS USER D: ALTER TABLE USER AGE INT NOT NULL
- 使用SQL语句将学生表STUDENT中的学生年龄AGE字段的值增加1岁,应该使用的命令是( )。 A: UPDATE SET AGE WITH AGE+1 B: REPLACE AGE WITH AGE+1 C: UPDATE STUDENT SET AGE=AGE+1 D: UPDATE STUDENT AGE WITH AGE+1
- 将STUDENT表中所有学生年龄AGE字段值增加1岁,应使用命令( ). A: REPLACE AGE WITH AGE+1 B: UPDATE SET AGE WITH AGE+1 C: UPDATE STUDENT AGE WITH AGE+1 D: UPDATE STUDENT SET AGE=AGE+1
- 使用SQL命令将STUDENT中的学生年龄AGE字段值增加1岁,应该使用的命令是( )。 A: REPLACE AGE WITH AGE+1 B: UPDATE STUDENT AGE WITH AGE+1 C: UPDATE STUDENT SET AGE=AGE+1 D: UPDATE SET AGE WITH AGE+1
内容
- 0
使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁,应该使用的命令是()。 A: UPDATE SET AGE WITH AGE 1 B: UPDATE STUDENT SET AGE AGE+ 1 C: UPDATE STUDENT AGE WITH AGE+ 1 D: REPLACE AGE WITH AGE+1
- 1
【多选题】下列SQL语句在实际运行时,可能转换的SQL语句为() update user <set> <if test="uname!=null">uname=#{uname}, </if> <if test="usex!=null">usex=#{usex}</if> </set> where uid=#{uid} A. update user set uname=#{uname} where uid=#{uid} B. update user set uname=#{uname}, usex=#{usex} where uid=#{uid} C. update user usex=#{usex} where uid=#{uid} D. update user set uname=#{uname}, usex=#{usex}
- 2
下列用于更新的SQL语句中,正确的是() A: update<br/>user set id = u001 ; B: update<br/>user(id,username) values('u001','jack'); C: update<br/>user set id='u001',username='jack'; D: update<br/>into user set id = 'u001', username='jack';
- 3
下面通过UPDATE语句将root用户的密码修改为mypwd2的语句中,正确的是 A: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; B: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' and Host='localhost'; C: UPDATE mysql.users SET Password=PASSWORD('mypwd2') WHERE User='root' OR Host='localhost'; D: UPDATE mysql.user SET Password=PASSWORD('mypwd2') WHILE User='root' OR Host='localhost';
- 4
若要删除基本表S中的Age列,应该选用的SQL语句是( )。 A: DELETE Age FROM S B: ALTER TABLE DROP Age C: UPDATE S Age D: ALTER TABLE S ‘Age’