Results 1 to 2 of 2

Thread: New to databases, simple setup error, plz help :(

  1. #1
    Join Date
    Feb 2005
    Posts
    11

    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

  2. #2
    Join Date
    Jan 2006
    Location
    Manchester England UK
    Posts
    225
    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
  •