返回数说广场
0
请查看以下语句和输出:DE
mysql> SHOW GRANTS FOR jsmith;
+---------------------------------------------+
| Grants for jsmith@% |
+---------------------------------------------+
| GRANT USAGE ON *.* TO 'jsmith'@'%' |
| GRANT UPDATE(Name) ON `world`.`country` TO 'jsmith'@'%' |
+---------------------------------------------+
2 rows in set (0.00 sec)
以下哪两个 SQL 语句可以被 jsmith 执行?
A
UPDATE world.country SET Name='first' ORDER BY Name LIMIT 1;
B
UPDATE world.country SET Name='new' WHERE Name='old';
C
UPDATE world.country SET Name=CONCAT('New ',Name);
D
UPDATE world.country SET Name='all';
E
UPDATE world.country SET Name='one' LIMIT 1;
0
0 133
分享
评论
热门数说


