#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Location
    rome, italy
    Posts
    16
    Rep Power
    0

    #1063 - Incorrect column specifier for column 'id_acquisto'


    Hi
    I'm trying to create a database from a dump but I get the error:

    #1063 - Incorrect column specifier for column 'id_acquisto'

    the following code is the beginning of the .sql I'm using and I can't find what's wrong with it, can anybody help please?

    --

    -- TABLE: acquisto

    --



    CREATE TABLE acquisto(

    id_acquisto DECIMAL(10, 0) auto_increment NOT NULL ,

    id_art DECIMAL(10, 0) NOT NULL,

    id_forn CHAR(2) NOT NULL,

    PRIMARY KEY (id_acquisto)

    )

    ;
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,727
    Rep Power
    4288
    auto_increment columns must be integer type (TINYINT, SMALLINT, INTEGER, or BIGINT)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Location
    rome, italy
    Posts
    16
    Rep Power
    0
    thanks a lot

IMN logo majestic logo threadwatch logo seochat tools logo