mysql insert?

[techker]

hey guys i got this from a book and it keeps on givving me erreurs on line 4

 

CREATE TABLE WROX_SHOP_INVENTORY (

ITEM_ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

ITEM_NAME VARCHAR(100) NOT NULL,

ITEM_DESCRIPTION TEXT DEFAULT ‘’,

PRICE DOUBLE(5,2) NOT NULL,

ITEM_IMAGE VARCHAR(255) NOT NULL,     

CATEGORY_ID INTEGER UNSIGNED NOT NULL,

 

  PRIMARY KEY (ITEM_ID),

 

FOREIGN KEY (CATEGORY_ID)

    REFERENCES WROX_SHOP_CATEGORY(CATEGORY_ID)

    ON DELETE CASCADE

)

 

ENGINE=InnoDB DEFAULT CHARACTER SET latin1

      COLLATE latin1_general_cs_AUTO_INCREMENT=0

[revraz]

What is ‘’ ?

[techker]

SQL query:

 

CREATE TABLE WROX_SHOP_INVENTORY(

 

ITEM_ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT ,

ITEM_NAME VARCHAR( 100 ) NOT NULL ,

ITEM_DESCRIPTION TEXT DEFAULT,

PRICE DOUBLE( 5, 2 ) NOT NULL ,

ITEM_IMAGE VARCHAR( 255 ) NOT NULL ,

CATEGORY_ID INTEGER UNSIGNED NOT NULL ,

PRIMARY KEY ( ITEM_ID ) ,

FOREIGN KEY ( CATEGORY_ID ) REFERENCES WROX_SHOP_CATEGORY( CATEGORY_ID ) ON DELETE CASCADE

) ENGINE = InnoDB DEFAULT CHARACTER SET latin1 COLLATE latin1_general_cs_AUTO_INCREMENT =0

 

MySQL said: 

 

#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 '

PRICE DOUBLE(5,2) NOT NULL,

ITEM_IMAGE VARCHAR(255) NOT NULL,     

CATEGORY' at line 4

 

if i remove the''

[revraz]

I meant you used non standard Quotes before.

[techker]

?this ,

[fenway]

?this ,

What on earth are you talking about.

[techker]

standard Quotes

 

where are they?i was saying maybe this( ,)

[fenway]

That's a comma... you were using ticks.  Use quotes (').

[techker]

supprising cause this comes out of a book??

 

is this cause of the version?

 

 

[fenway]

supprising cause this comes out of a book??

 

is this cause of the version?

Nope.