java.sql.SQLSyntaxErrorException:提供的名称不在有效列标签列表中:

时间:2021-07-05 04:50:36

my query

SELECT COUNT(*) as count FROM datasquare.users WHERE email_id = '"yup@krish.com"' and 
password = '"krish"' ALLOW FILTERING

my table

 email_id        | password | user_id | user_name
-----------------+----------+---------+-----------
 vamsi@gmail.com |  krishna |    2915 |     vamsi

1 个解决方案

#1


0  

You can't use count as a label

您不能将count用作标签

as count

Use instead total or something along the lines of

使用相反的总数或类似的东西

as total_users

or similar to avoid using a reserved keyword.

或类似的,以避免使用保留关键字。

#1


0  

You can't use count as a label

您不能将count用作标签

as count

Use instead total or something along the lines of

使用相反的总数或类似的东西

as total_users

or similar to avoid using a reserved keyword.

或类似的,以避免使用保留关键字。