mysql double-quoted table names

by

Taken from this post:

SET GLOBAL SQL_MODE=ANSI_QUOTES;

Personally when I tested, I had to do it like this:

SET SQL_MODE=ANSI_QUOTES;

I don’t think there’s any other way.

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes

ANSI_QUOTES

Treat “”” as an identifier quote character (like the “`” quote
character) and not as a string quote character. You can still use “`”
to quote identifiers with this mode enabled. With ANSI_QUOTES enabled,
you cannot use double quotation marks to quote literal strings,
because it is interpreted as an identifier.

More Related Contents:

  1. How to use IN & NOT IN same query [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL: Large VARCHAR vs. TEXT?
  4. MySQL: is a SELECT statement case sensitive?
  5. Check overlap of date ranges in MySQL
  6. Multiple-column foreign key in MySQL?
  7. mysql – making a mechanism similar to Oracle’s seqences
  8. Get the latest date from grouped MySQL data
  9. How to execute a MySQL command from a shell script?
  10. UUID performance in MySQL?
  11. Select most common value from a field in MySQL
  12. MySQL: NULL vs “”
  13. MySQL update a joined table
  14. Returning the ‘last’ row of each ‘group by’ in MySQL
  15. Optimal MySQL settings for queries that deliver large amounts of data?
  16. mysql configuration stops at “starting server”
  17. MySQL Error 1264: out of range value for column
  18. Like Case Sensitive in MySQL
  19. What is the best way to delete old rows from MySQL on a rolling basis?
  20. What are the known ways to store a tree structure in a relational DB? [closed]
  21. Illegal mix of collations error in MySql
  22. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  23. mysql equivalent data types
  24. Get difference in years between two dates in MySQL as an integer
  25. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  26. Check if a column exists in a table with MySQL
  27. Data truncated for column?
  28. Connect to Docker MySQL container from localhost?
  29. Using MySQL triggers to log all table changes to a secondary table
  30. MySQL search json value by key in array

Leave a Comment