What is the difference between the backtick and the square bracket in SQL statements?

by

SQL Server/T-SQL uses square brackets (as well as MS Access), while MySQL uses backticks.

As far as I know, can turn up in documentation, or use in testing, square brackets are not valid for MySQL. So if you need to enclose a keyword as a table name in SQL Server, use [], and in MySQL use backticks, or double-quotes when ANSI_QUOTES is enabled.

From the documentation:

The identifier quote character is the backtick (“`”):

mysql> SELECT * FROM `select` WHERE `select`.id > 100;

If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks:

mysql> CREATE TABLE "test" (col INT);
ERROR 1064: You have an error in your SQL syntax...
mysql> SET sql_mode="ANSI_QUOTES";
mysql> CREATE TABLE "test" (col INT);
Query OK, 0 rows affected (0.00 sec)

More Related Contents:

  1. Why do I get an error from this sub query script?
  2. sql query to modify the selected value from database [closed]
  3. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  4. Can I concatenate multiple MySQL rows into one field?
  5. How do I query between two dates using MySQL?
  6. MySQL: @variable vs. variable. What’s the difference?
  7. How to do the Recursive SELECT query in MySQL?
  8. MySQL, update multiple tables with one query
  9. Join between tables in two different databases?
  10. How to select a column name with a space in MySQL [duplicate]
  11. Can a table field contain a hyphen?
  12. How do I use on delete cascade in mysql?
  13. Adding a leading zero to some values in column in MySQL
  14. Using SQL to determine word count stats of a text field
  15. Update one MySQL table with values from another
  16. MySQL JOIN the most recent row only?
  17. How to transpose mysql table rows into columns
  18. MySQL Group By and Sum total value of other column
  19. MySQL incorrect key file for tmp table when making multiple joins
  20. What does SQL clause “GROUP BY 1” mean?
  21. Does the order of conditions in a WHERE clause affect MySQL performance?
  22. Syntax error when using except in a query
  23. MySQL query, MAX() + GROUP BY
  24. How do I delete all the duplicate records in a MySQL table without temp tables
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. MySQL for replace with wildcard
  27. Syntax error: WITH is not valid input in this position
  28. Update MySQL with if condition
  29. “Unknown column in ‘field list'”, but column does exist
  30. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’

Leave a Comment