Do different databases use different name quote?

by

This use of quotes is called delimited identifiers. It’s an important part of SQL because otherwise you can’t use identifiers (e.g. table names and column names) that:

  • Include whitespace: “my table”
  • Include special characters and punctuation: “my-table”
  • Include international characters: “私のテーブル”
  • Are case-sensitive: “MyTable”
  • Match SQL keywords: “table”

The standard SQL language uses double-quotes for delimited identifiers:

SELECT * FROM "my table";

MySQL uses back-quotes by default. MySQL can use standard double-quotes:

SELECT * FROM `my table`;
SET SQL_MODE=ANSI_QUOTES;
SELECT * FROM "my table";

Microsoft SQL Server and Sybase uses brackets by default. They can both use standard double-quotes this way: 

SELECT * FROM [my table];
SET QUOTED_IDENTIFIER ON;
SELECT * FROM "my table";

InterBase and Firebird need to set the SQL dialect to 3 to support delimited identifiers.

Most other brands of database use double-quotes correctly.

More Related Contents:

  1. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  2. 1052: Column ‘id’ in field list is ambiguous
  3. How to do a batch insert in MySQL
  4. Count the occurrences of DISTINCT values
  5. Codeigniter – multiple database connections
  6. Location of my.cnf file on macOS
  7. How to do Inheritance Modeling in Relational Databases?
  8. What’s the difference between ” = null” and ” IS NULL”?
  9. Maximum number of records in a MySQL database table
  10. Swapping column values in MySQL
  11. MySQL stored procedures use them or not to use them
  12. In SQL, is it OK for two tables to refer to each other?
  13. Is there a Profiler equivalent for MySql? [closed]
  14. Cast int to varchar
  15. Import SQL file into mysql
  16. How to skip certain database tables with mysqldump?
  17. “where 1=1” statement [duplicate]
  18. How do you debug MySQL stored procedures?
  19. Meaning of “n:m” and “1:n” in database design
  20. How to set a MySQL row to READ-ONLY?
  21. mySQL – Create a New Table Using Data and Columns from Three Tables
  22. Case Sensitive collation in MySQL
  23. Can’t import database through phpmyadmin file size too large
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. What is the best way to do incremental backups in MySQL?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How to store a one to many relation in MySQL database?
  29. Inventory management with stock options
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment