title: How do I escape reserved words used as column names? MySQL/Create Table
body: <p>I am generating tables from classes in .NET and one problem is a class may have a field name <code>key</code> which is a reserved MySQL keyword. How do I escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique)</p>
  
  <pre><code>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;
  </code></pre>