web123456

syntax err orator near “.

### 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 the34characters nearby.

2. View sql

select ,,, , from user where id = 1

The34Characters 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