-
New to databases, simple setup error, plz help :(
im using phpmyadmin heres wot i get cum up
CREATE TABLE `products` (
`name` CHAR( 255 ) UNSIGNED,
`category` CHAR( 255 ) ,
`manufacturer` CHAR( 255 ) ,
`type` CHAR( 255 ) ,
`group` CHAR( 255 ) ,
`price` DECIMAL( 6 ) UNSIGNED,
`smalldesc` CHAR( 255 ) UNSIGNED,
`fulldesc` VARCHAR( 1000 ) UNSIGNED,
`smallimage` CHAR( 255 ) UNSIGNED,
`largeimage` CHAR( 255 ) UNSIGNED,
`stock` SMALLINT( 2 ) UNSIGNED,
FULLTEXT (
`name` ,
`category` ,
`manufacturer` ,
`type` ,
`group`
)
) COMMENT = 'Product Generation Database'
You have an error in your SQL syntax near 'UNSIGNED, `category` CHAR(255), `manufacturer` CHAR(255), `type` CHAR(255), `gro' at line 1
wot does this mean please. thankyou
-
you can't have an unsigned varchar.
unsigned refers to a number e.g. -1 or 1
an unsigned number does not have a + or -
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules