下面语句可以实现查询user表中的user,password,logins信息的是
A、select logins,user,password from user;
B、select user,password,logins, from user;
C、select password,logins,user from user;
D、select user,password,logins from user;
A、select logins,user,password from user;
B、select user,password,logins, from user;
C、select password,logins,user from user;
D、select user,password,logins from user;
A、select logins,user,password from user where name like ’%zhangsan%’;
B、select user,password,logins, from user where name like ’zhangsan’;
C、select password,logins,user from user where name=’zhangsan’ limit 1;
D、select user,password,logins from user where name=’zhangsan’;
A、select user,password,logins from user group by logins;
B、select password,logins,user from user order by logins;
C、select user,password,logins, from user order by logins;
D、select logins,user,password from user order by logins desc;
A、查询user表中的所有数据
B、与“delete from user;“完全一样
C、删除user表,并再次创建user表
D、删除user表
A、delete from user;
B、drop from user;
C、truncate table user;
D、delete from user where 1=1;
______UPDATE ON T FROM User
A.可以通过mysql的SCHEMATA表查询表信息
B.可以通过TABLES表查询列信息
C.可以通过COLUMNS表查询具体数据
D.可以通过user表查询数据库用户信息
______UPDATE ON T FROM User
“把查询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
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!