MySQL:SQL 语法错误

Question

我正在尝试从 MySQL 表中收集/选择数据，以根据 cSV 文件中的新数据检查它，然后更新它。我坚持选择脚本的数据部分。

这是错误信息:

Error at line 44 in /home/atkelect/public_html/test/ap/import_list.php 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 'FROM products WHERE products_model = 'A040503'' at line 1

SELECT products_id, list_price, FROM products WHERE products_model = 'A040503'

[TEP停止]

这是第 44 行:

  $product_query = tep_db_query("SELECT products_id, list_price, FROM ".TABLE_PRODUCTS." WHERE     products_model = '".tep_db_input($line[0])."'");

Answer 1

去掉list_price后面的逗号，应该是这样的

SELECT products_id, list_price FROM...