title: SQL Product Table Creation - Incorrect Syntax
body: <p>I am trying to create a products table running the following SQL query:</p>
  
  <pre><code>CREATE TABLE ‘products’ (
    ‘id’ INT NOT NULL AUTO_INCREMENT ,
    ‘name’ VARCHAR( 255 ) NOT NULL ,
    ‘shortdesc’ VARCHAR( 255 ) NOT NULL ,
    ‘longdesc’ TEXT NOT NULL ,
    ‘thumbnail’ VARCHAR( 255 ) NOT NULL ,
    ‘image’ VARCHAR( 255 ) NOT NULL ,
    ‘sizes’ ENUM( ‘s’, ‘m’, ‘l’, ‘xl’ ) NOT NULL ,
    ‘colors’ ENUM( ‘red’, ‘blue’, ‘green’, ‘brown’, ‘white’, ‘black’ ) NOT NULL ,
    ‘grouping’ VARCHAR( 16 ) NOT NULL ,
    ‘status’ ENUM( ‘active’, ‘inactive’ ) NOT NULL ,
    ‘category_id’ INT NOT NULL ,
    ‘featured’ ENUM (‘true’, ‘false’) NOT NULL,
    ‘price’ FLOAT( 4, 2 ) NOT NULL,
  PRIMARY KEY ( ‘id’ )
  ) TYPE = MYISAM ;
  </code></pre>
  
  <p>However this error occurs: </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 '‘s’, ‘m’, ‘l’, ‘xl’ ) NOT NULL , ‘colors’ ENUM( ‘red’, ' at line 8
  </code></pre>
  
  <p>Which type should I use? I am following an example from a book.</p>