title: SQL #1064 Syntax Error
body: <p>What is wrong with the following?</p>
  
  <p><strong>Error</strong></p>
  
  <blockquote>
    <p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(
    <code>cp_id</code> INT( 11 ) NOT NULL,
    <code>cp_model</code> INT( 11 ) NOT NULL,
    <code>cp_name</code> VAR' at line 1 </p>
  </blockquote>
  
  <p><strong>SQL</strong></p>
  
  <pre><code>CREATE DATABASE `car_parts` (
   `cp_id` INT( 11 ) NOT NULL auto_increment,
   `cp_model` INT( 11 ) NOT NULL,
   `cp_name` VARCHAR( 255 ) NOT NULL,
   `cp_image` VARCHAR( 255 ) NOT NULL,
   `cp_cost` INT( 11 ) NOT NULL,
   `cp_speed` INT( 11 ) NOT NULL,
   `cp_control` INT( 11 ) NOT NULL,
   `cp_power` INT( 11 ) NOT NULL,
   `cp_available` INT( 11 ) NOT NULL,
   PRIMARY KEY (`car_parts`)
   ) TYPE=MYISAM ;
  </code></pre>
  
  <p>so i did what you lot said and now this is the error i get :(</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that
  corresponds to your MariaDB server version for the right syntax to use
  near 'TYPE=MYISAM' at line 12 
  </code></pre>