sql错误？SELECT COUNT(id) AS SP_COUNTER FROM

Question

SELECT COUNT(id) AS SP_COUNTER FROM fanwe_supplier_location WHERE is_effect=1 and city_id=18

这行sql语句写错了吗？

Answer 1

看不出，排查
1、表，字段名是否错了呢?
2、是否有不可见字符。