c# - 您的 SQL 语法有错误

Question

我做错了什么？ C# 翻译有问题吗？

string commandText = 
  @"SELECT sc.sc_n,
           sc.provider_n,
           sc.sc_external_id,
           sc.sc_external_name 
      FROM t_supplier_codification sc 
     WHERE sc.product_articul IS NULL 
       AND (sc.sc_external_name != "") 
       AND sc_count >= 1 
       AND provider_n=19 
       AND LENGTH(sc.sc_external_name)>=10 
       AND sc_external_name NOT LIKE '%лента%' 
       AND sc_external_name NOT LIKE '%камера%' 
       AND sc_external_name NOT LIKE '%Replica%' 
       AND sc_external_name NOT LIKE '%ET%' 
       AND sc_external_name LIKE ''
  ORDER BY sc_external_name";

您的 SQL 语法有错误:

check the manual that corresponds to your MySQL server version for the right syntax to use near '") AND sc_count >= 1 AND provider_n=19 AND LENGTH

Answer 1

您需要使用单引号而不是双引号:

(sc.sc_external_name!='')

作为双引号终止您的字符串。此外，单引号通常用于 SQL 中的字符串文字，双引号用于列名(和其他对象)。