我在自己电脑上phpmyadmin运行没有问题
但放到服务器上却出问题了,服务器mysql mysql 4.0.27SELECT * FROM company_customer_category WHERE customer_category_id IN (SELECT customer_category_id FROM company_customer_category_to_customer WHERE customer_id=1)报错如下:
错误
SQL 查询: SELECT *
FROM company_customer_category
WHERE customer_category_id
IN (
SELECT customer_category_id
FROM company_customer_category_to_customer
WHERE customer_id =1
)
LIMIT 0 , 30 MySQL 返回: #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 customer_category_id FROM company_customer_category_to_c
但放到服务器上却出问题了,服务器mysql mysql 4.0.27SELECT * FROM company_customer_category WHERE customer_category_id IN (SELECT customer_category_id FROM company_customer_category_to_customer WHERE customer_id=1)报错如下:
错误
SQL 查询: SELECT *
FROM company_customer_category
WHERE customer_category_id
IN (
SELECT customer_category_id
FROM company_customer_category_to_customer
WHERE customer_id =1
)
LIMIT 0 , 30 MySQL 返回: #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 customer_category_id FROM company_customer_category_to_c
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货