title: How to add a column and make it a foreign key in single MySQL statement?
body: <p>In mysql, can I add a column and foreign key in the same statement?  And what is the proper syntax for adding the fk?</p>
  
  <p>Here is my SQL:</p>
  
  <pre><code>ALTER TABLE database.table
   ADD COLUMN columnname INT DEFAULT(1),
   FOREIGN KEY (fk_name) REFERENCES reftable(refcolumn) ON DELETE CASCADE;
  </code></pre>
  
  <p>...and the accompanying error message:</p>
  
  <blockquote>
    <p>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 'FOREIGN KEY (fk_name) REFERENCES reftable(refcolumn) ON DELETE CASCADE' at line 4</p>
  </blockquote>