暂无图片
返回数说广场
逸晨
2024-12-13
请查看以下语句和输出: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
分享

评论

热门数说