title: I don't understand why this code is throwing an Error?
body: <p>I'm running the following code in MySQL Workbench:</p>
  <pre><code>CREATE TABLE beer_type ( -- create beer table
  type_id INTEGER NOT NULL PRIMARY KEY, -- PK &quot;type_id&quot;
  beer_name VARCHAR(30) NOT NULL,
  beer_type VARCHAR(30) NOT NULL,
  beer_id INTEGER NOT NULL,
  FOREIGN KEY (beer_id) REFERENCES beer (beer_id));
  </code></pre>
  <p>I'm getting:</p>
  <pre><code>0   5   21:27:10    CREATE TABLE beer_type ( -- create beer table   Error 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 '' at line 1    0.000 sec
  </code></pre>
  <p>I'm new to SQL so this is a bit confusing to me and my professor isn't the best of help...
  Any way anyone can help would be greatly appreciated!!</p>