MySql error

[lionheart81]

What's wrong with this

CREATE TABLE `products` (

`item_num` VARCHAR( 255 ) NOT NULL ,
`description` VARCHAR( 255 ) NOT NULL ,
`quantity` TINYTEXT( 255 ) NOT NULL ,
`type` TINYTEXT( 255 ) NOT NULL ,
PRIMARY KEY ( `item_num` ) 
) 

MySQL said:

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
'( 255 ) NOT NULL , type TINYTEXT( 255 ) NOT NULL , PR

[maritime_coder]

this works

CREATE TABLE products (

itemnum VARCHAR( 255 ) NOT NULL ,
description VARCHAR( 255 ) NOT NULL ,
quantity TINYTEXT NOT NULL ,
type TINYTEXT NOT NULL ,
PRIMARY KEY ( itemnum )
);

// I just removed (255)

[Frederick]

CREATE TABLE products (
item_num VARCHAR(255) NOT NULL default '', 
description VARCHAR(255) NOT NULL default '', 
quantity TINYTEXT NOT NULL , 
type TINYTEXT NOT NULL , 
PRIMARY KEY (item_num)
);