mysql - SQL 语法错误 db_query

Question

我正在尝试运行来自 Adminer 4.6.2 的以下查询，它给了我模糊的“语法错误”，没有更多详细信息:

 db_query("DELETE FROM {field_collection_item} WHERE field_name NOT IN (SELECT field_name FROM {field_config} WHERE type = 'field_collection')");

我也尝试过这个:

DELETE FROM {field_collection_item} WHERE field_name NOT IN (SELECT field_name FROM {field_config} WHERE type = 'field_collection')

但它返回相同的语法错误。

Answer 1

不要使用双引号，使用2个单引号''，过滤条件要求值用单引号括起来。验证您的代码始终是一个好习惯，您可以使用 Print @sql 来做到这一点

例如:

DECLARE @sql VARCHAR(max)

SET @sql = 'DELETE FROM [field_collection_item] WHERE field_name
               NOT IN (SELECT field_name FROM [field_config] WHERE type = ''field_collection'')'

PRINT @sql

打印:

    DELETE FROM [field_collection_item] WHERE field_name NOT IN 
   (SELECT field_name FROM [field_config] WHERE type = 'field_collection')