要在user表中更新记录,哪条语句是正确的?
A、Update user Set intAge=18
B、Update user Set dateLogin=’2019-10-1’ Where strName=’zhangsan’
C、Update user Set strName=zhangsan,intAge=22 Where strName=zhangsan
D、Update user Set strName="zhangsan",intAge=22 Where ID=2
A、Update user Set intAge=18
B、Update user Set dateLogin=’2019-10-1’ Where strName=’zhangsan’
C、Update user Set strName=zhangsan,intAge=22 Where strName=zhangsan
D、Update user Set strName="zhangsan",intAge=22 Where ID=2
A、insert into user(username,password,logins) values(‘zhangsan’,’654321’,1);
B、update user set logins= logins +1 where username=’zhangsan’;
C、update user set logins =’ logins+1’ where username=’zhangsan’;
D、update user logins = logins+1 where username=’zhangsan’;
A、update user logins = logins+1 where username=’zhangsan’;
B、update user set logins =’ logins+1’ where username=’zhangsan’;
C、update user set logins= logins +1 where username=’zhangsan’;
D、insert into user(username,password,logins) values(‘zhangsan’,’654321’,1);
A.UPDATE只能更新表中的部分记录
B.UPDATE只能更新表中的全部记录
C.UPDATE语句更新数据时可以有条件的更新记录
D.以上说法都不对
“把查询sc表和更新sc表的grade列的权限授予用户user”的正确SQL语句是()。
A)GRANT SELECT sc,UP DATE sc.Grade TO user
B)GRANT SELECT,UP DATE (grade) ON TABLE sc TO user
C)GRANT SELECT,UP DATE ON TABLE sc.Grade TO user
D)GRANT SELECT ON TABLE sc,UP DATE ON TABLE sc(grade) TO user
A、select username,logins from user where logins>5;
B、select logins from user where logins>5;
C、select username from user where logins>5;
D、select * from user where logins>5;
A、查询user表中的所有数据
B、与“delete from user;“完全一样
C、删除user表,并再次创建user表
D、删除user表
要在 “ 成绩 ” 表中插入一条记录 , 应该使用的 SQL 语句是:【 14 】 成绩 (学号 , 英语 , 数学 , 语文 ) V A L UES (" 2001100111 " ,9l,78,86)
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!