### SQL: select ,,, , from user where id = 1
### Cause: : ERROR: syntax error at or near "."
Position: 34
; bad SQL grammar [];nested exception is : ERROR: syntax error at or near "."
Position: 34
1. Learn how to locate the SQL problem based on error information
Ideas:
1. ERROR: syntax error at or near “.” Position: 34
The meaning of this sentence is that the problem appears in the34
characters nearby.
2. View sql
select ,,, , from user where id = 1
The34
Characters are special symbols.
, check this.
Is there any incorrect writing of attachments to special symbols?
I observed carefully and found that there was no comma written later,
Causes syntax error
2. Error SQL solution
Correct sql:
select ,,,,, from user where id = 1
Error sql:
select ,,, , from user where id = 1