If you want to use a number with 10 digits and no decimal places, try using one
of the following:
int value range -2147683648 to 2147683647
int unsigned value range 0 to 4294967295
bigint value range -9223372036854775808 to 9223372036854775807
bigint unsigned value range 0 to 18446744073709551615
I've never heard of a "NUMERIC" type in MySQL, but I've only been using it since
last June, so I just may not have run into it yet.
Mike Vesey wrote:
>
> Hello,
> I have a bunch of tables running on 3.22.32 and they work fine. When I
> tried creating these tables on 3.23.32 I get the following message for given
> fields.
> "Incorrect column specifier for column 'ACCOUNT_ID'" (or whatever the
> column id is.)
>
> Here is a the table syntax: The error occurs on ACCOUNT_ID on this table.
>
> create table DBACCOUNT (
> ACCOUNT_ID NUMERIC(10,0) NOT NULL AUTO_INCREMENT PRIMARY KEY,
> ACCOUNT_NUM VARCHAR(30) NOT NULL,
> PASSWD VARCHAR(30) NOT NULL,
> UNIQUE(ACCOUNT_NUM,PASSWD),
> TITLE VARCHAR(15),
> FIRST_NAME VARCHAR(30),
> MIDDLE_INIT VARCHAR(30),
> LAST_NAME VARCHAR(30),
> NAME_SUFFIX VARCHAR(30),
> ACTIVE VARCHAR(10),
> EMAIL VARCHAR(255),
> ADDRESS1 VARCHAR(40),
> ADDRESS2 VARCHAR(40),
> CITY VARCHAR(40),
> STATE_PROV VARCHAR(40),
> POSTAL_CODE VARCHAR(40),
> COUNTRY_CODE VARCHAR(40),
> PHONE VARCHAR(32)
> )
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Angela Curtis
Innovative Business Consultants
http://www.ibc2001.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
