title: mySQL - create table error 1064(42000): syntax error
body: <p>I'm trying to create the table below but I get an error. I double checked and the data types are valid, and a table with this name doesn't currently exist in the database. I even closed and re-opened my terminal in case this was a glitch. But still no luck. Any idea what's wrong here?</p>
  <pre><code>create table order (order_no int, purch_amt decimal(6,2), order_date date, customer_id int, salesman_id int);
  </code></pre>
  <p>Error message I get:
  ERROR 1064 (42000): 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 (order_no int, purch_amt decimal(6,2), order_date date, customer_id int, s' at line 1</p>