title: MYSQL table creation error #1072
body: <p>I ran an SQL query as follows in MYSQL:</p>
  
  <pre><code>CREATE TABLE `table1_companies` (
    `company_id` int(11) NOT NULL AUTO_INCREMENT,
    `RSSD9001` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`company_id`),
    KEY `index1` (`RSSDID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  </code></pre>
  
  <p>And got the following error:</p>
  
  <pre><code> #1072 - Key column 'RSSDID' doesn't exist in table `
  </code></pre>
  
  <p>Any thoughts? I am new to MYSQL.  The table does not already exist in my database.</p>