MySQL 子查询在 MySQL 4.0 上失败并出现无效语法错误

发布于 2024-09-09 08:08:30 字数 767 浏览 7 评论 0原文

我正在 MySQL 4.0.30 上运行一个非常基本的子查询。
我的目标是从 mysql.user 表中获取对特定数据库具有授权的任何用户的用户权限，如 mysql.db 表中所述。查询如下所示：

mysql> select * from mysql.user where User IN 
   (select User from mysql.db where Db='db_name')\G

如您所见，它非常基本并且遵循 MySQL 手册中的子查询语法。但是，当我执行该命令时，它会出现以下响应错误：

ERROR 1064: You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 'select
User from mysql.db where Db='db_name')' at line 1

我还尝试使用 = ANY 而不是 IN 执行该命令。我在 4.1 和 5.0 版本的 MySQL 上运行了相同的查询。对此的任何帮助或见解表示赞赏。谢谢

原文

I'm running a pretty basic subquery on MySQL 4.0.30.
My goal is to get the user permissions from the mysql.user table for any user with grants on a specific database, as noted in the mysql.db table. The query looks like this:

mysql> select * from mysql.user where User IN 
   (select User from mysql.db where Db='db_name')\G

As you can see, it's pretty basic and follows the subquery syntax in the MySQL manual. However, when I execute that, it errors with the following response:

ERROR 1064: You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 'select
User from mysql.db where Db='db_name')' at line 1

I also tried the command with = ANY instead of IN. I've run the same query on 4.1 and 5.0 versions of MySQL. Any help or insight on this is appreciated. Thanks

分享到QQ

分享到微博