I am teaching my self database and I ran into a snage, my table will not build right.
here is my bad code
CREATE TABLE `Monitors` (
`Type` TEXT( 25 ) NOT NULL ,
`Size` INT( 10 ) NOT NULL ,
`Price` FLOAT( 10 ) NOT NULL ,
`Descripton` LONGTEXT( 60 ) NOT NULL ,
PRIMARY KEY ( `Type` )
) COMMENT = \'The type, size, price, and description of the moniters in stock.\'
and here is the error
MySQL said:
You have an error in your SQL syntax near \'(25) NOT NULL, `Size` INT(10) NOT NULL, `Price` FLOAT(10) NOT NULL, `Descripton`\' at line 1
P.S. This is not a home work or anything, this is just a exsample database
Any help would be cool