Syntax error near '

Source: Internet
Author: User

No matter where you go wrong, it's usually a SQL syntax error.


To find the SQL statement


In a rough look, I thought it was 1=1 here.

It is possible to compile the sentence by removing the where.

The real situation is that the error is out of this sentence, but not 1=1 here, but where the front of a space is missing, resulting in the table name and the previous sentence together, directly let 1=1 front no SQL keyword, so reported ' 1 ' near the syntax error.

And there are spaces in front of the conditional statements.

Syntax error near '

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.