title: MYSQL create table error with multiple foreign keys
body: <p>I'm trying to create a table with multiple foreign keys, and am getting an error.  I am unsure what I'm doing wrong, and I've been tinkering with it for a while.  I'm sure its something small and stupid, but help is appreciated.</p>
  
  <pre><code>Create table Order(
  order_number INT AUTO_INCREMENT,
  product_id INT(11) NOT NULL,
  address_id INT(11) NOT NULL,
  user_id INT(11) NOT NULL,
  quantity INT(3) NOT NULL,
  size VARCHAR(20) NOT NULL,
  status VARCHAR(20) NOT NULL,
  order_date DATE NOT NULL,
  PRIMARY KEY (order_number),
  FOREIGN KEY (user_id)
  REFERENCES User (user_id),
  FOREIGN KEY (product_id)
  REFERENCES Product (product_id),
  FOREIGN KEY (address_id)
  REFERENCES Address (address_id)
  )ENGINE = INNODB
  </code></pre>
  
  <p>The specific error I get is:</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 'Order(
  </code></pre>
  
  <p>order_number INT AUTO_INCREMENT,
  product_id INT(11) NOT NULL,
  address_' at line 1 </p>