How do I escape reserved words used as column names? MySQL/Create Table

by

You can use double quotes if ANSI SQL mode is enabled 

CREATE TABLE IF NOT EXISTS misc_info
  (
     id    INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
     "key" TEXT UNIQUE NOT NULL,
     value TEXT NOT NULL
  )
ENGINE=INNODB;

or the proprietary back tick escaping otherwise. (Where to find the ` character on various keyboard layouts is covered in this answer)

CREATE TABLE IF NOT EXISTS misc_info
  (
     id    INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
     `key` TEXT UNIQUE NOT NULL,
     value TEXT NOT NULL
  )
ENGINE=INNODB;

(Source: MySQL Reference Manual, 9.3 Reserved Words)

More Related Contents:

  1. How to escape apostrophe (‘) in MySql?
  2. How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?
  3. What characters have to be escaped to prevent (My)SQL injections?
  4. How to escape apostrophe (a single quote) in MySql?
  5. SQL select only rows with max value on a column [duplicate]
  6. How to create a MySQL hierarchical recursive query?
  7. What is the error “Every derived table must have its own alias” in MySQL?
  8. How to enable MySQL Query Log?
  9. Join between tables in two different databases?
  10. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  11. Mysql: Select all data between two dates
  12. mysql two column primary key with auto-increment
  13. Are you allowed to use numbers as table names in MySQL?
  14. MySQL error code: 1175 during UPDATE in MySQL Workbench
  15. How do you select every n-th row from mysql
  16. How to take backup of a single table in a MySQL database?
  17. Add Foreign Key to existing table
  18. MySQL maximum memory usage
  19. MySQL JOIN the most recent row only?
  20. Bogus foreign key constraint fail
  21. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  22. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  23. Easiest way to copy a table from one database to another?
  24. Using index, using temporary, using filesort – how to fix this?
  25. sql like operator on integer
  26. How to get the max of two values in MySQL?
  27. How to make a primary key start from 1000?
  28. MySQL – SELECT * INTO OUTFILE LOCAL ?
  29. Mysql stored procedure don’t take table name as parameter
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment