mySql 查询给我语法错误

Question

这个问题已经有答案了:

Syntax error due to using a reserved word as a table or column name in MySQL (1 个回答)

已关闭 6 年前。

在 phpMyAdmin 中给我这个错误:

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 'table ON brand.seo_name = table.brandName ORDER BY b' at line 8

这是查询:

SELECT brand.name, brand.seo_name
FROM brand
JOIN (
    SELECT IFNULL(product.brand, standard_product.brand) AS brandName
    FROM product
    JOIN standard_product
    ON product.standard_product_id = standard_product.id
    WHERE product.store_id = 1) AS table
ON brand.seo_name = table.brandName

ORDER BY brand.seo_name ASC
LIMIT 0,30

Answer 1

table 是保留字。您应该选择不同的别名，例如t:

SELECT brand.name, brand.seo_name
FROM brand
JOIN (
    SELECT IFNULL(product.brand, standard_product.brand) AS brandName
    FROM product
    JOIN standard_product
    ON product.standard_product_id = standard_product.id
    WHERE product.store_id = 1) t
ON brand.seo_name = t.brandName
ORDER BY brand.seo_name ASC
LIMIT 0,30