title: I get an MYSQL error #1064 when add foreign key constraint
body: <p>I keep getting this sql error </p>
  
  <pre><code>"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Option (OptionId)' at line 1"
  </code></pre>
  
  <p>when I try and add a foreign key to the OptionId field from the Question Table to the OptionId(pk) field in the Option field. I don't get wy I keep getting the error because I don't see what is wrong with it.</p>
  
  <p>Below is the foreign key constraint using ALTER TABLE:</p>
  
  <pre><code>ALTER TABLE Question ADD CONSTRAINT FK_OptionId FOREIGN KEY (OptionId) REFERENCES Option (OptionId)
  </code></pre>
  
  <p>Table names and syntax are correct, I made sure by double checking.</p>
  
  <p>Why is it not working?</p>