Using backticks around field names

by

Using backticks permits you to use alternative characters. In query writing it’s not such a problem, but if one assumes you can just use backticks, I would assume it lets you get away with ridiculous stuff like

SELECT `id`, `my name`, `another field` , `field,with,comma`

Which does of course generate badly named tables.

If you’re just being concise I don’t see a problem with it,
you’ll note if you run your query as such

EXPLAIN EXTENDED Select foo,bar,baz

The generated warning that comes back will have back-ticks and fully qualified table names. So if you’re using query generation features and automated re-writing of queries, backticks would make anything parsing your code less confused.

I think however, instead of mandating whether or not you can use backticks, they should have a standard for names. It solves more ‘real’ problems.

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. Get records with max value for each group of grouped SQL results
  3. How do I escape reserved words used as column names? MySQL/Create Table
  4. How to store multiple options in a single table?
  5. MySQL and GROUP_CONCAT() maximum length
  6. What data type to use for hashed password field and what length?
  7. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  8. MySQL pagination without double-querying?
  9. MySQL convert date string to Unix timestamp
  10. How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
  11. MySql Table Insert if not exist otherwise update
  12. How to get difference between two dates in months using MySQL query?
  13. MySQL – Control which row is returned by a group by
  14. Can MySQL replace multiple characters?
  15. My MySQL trigger doesn’t work, simple syntax, not complicated
  16. Using ORDER BY and GROUP BY together
  17. How can VBA connect to MySQL database in Excel?
  18. Select a column with a keyword name
  19. Sum results of a few queries and then find top 5 in SQL
  20. ERROR 1148: The used command is not allowed with this MySQL version
  21. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  22. Use Composite Primary Key as Foreign Key
  23. WooCommerce: Finding the products in database
  24. Mysql performance on 6 million row table
  25. How can I “select *” from a table in MySQL but omit certain columns?
  26. For homebrew mysql installs, where’s my.cnf?
  27. MySQL Select Multiple VALUES
  28. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment