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
