Help Center/ Relational Database Service/ Troubleshooting/ RDS for MySQL/ SQL Issues/ Double Quotation Marks Cannot Be Identified During SQL Statement Execution
Updated on 2024-12-13 GMT+08:00
View PDF
Share

Double Quotation Marks Cannot Be Identified During SQL Statement Execution

Scenario

Double quotation marks cannot be identified when SQL statements are executed on an RDS for MySQL instance.

Troubleshooting

Check whether the sql_mode parameter is set to ANSI_QUOTES.

If it is set to ANSI_QUOTES, double quotation marks are considered as identifier quote characters. For details, see Server SQL Modes.

Figure 1 Checking the parameter value

Solution

Delete ANSI_QUOTES from the values of sql_mode.

Parent topic: SQL Issues