title: Not able to resolve MySQL error #1064
body: <p>My query seems to be ok as far as my knowledge goes:</p>
  
  <pre><code>CREATE TABLE PORTAL_NOTES (
      id numeric NOT NULL,
      school_id numeric,
      syear numeric(4,0),
      title character varying(255),
      content character varying(5000),
      sort_order numeric,
      published_user numeric,
      published_date timestamp(0),
      start_date date,
      end_date date,
      published_profiles character varying(255)
  );
  </code></pre>
  
  <p>But I get this 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 '(1) , start_date date, end_date date, published_profiles characte' at line 9
  </code></pre>
  
  <p>Can anyone help me debug the problem here?</p>