On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote:
>
> Hi all,
>
> I've started using MySQL for the first time and I'm hvaing a bit of a problem with
>defining an AUTO_INCREMENT column. I'm using ver 3.23.32 which I downloaded for
>Linux and Win2k. I am having this problem on both systems.
>
> Ok if I try to run the create table statement:
>
> create table test
> (id_pk numeric(10) AUTO_INCREMENT)
>
> I get the error:
>
> Error while executing statement:
> Invalid argument value: Incorrect column specifier for column 'id_pk'
> Correct the statement and do another try!
>
>
> Does anyone know why this happens? Am I missing something that needs to included
>during compilation?
Nope, it's just that AUTO_INCREMENT can only be used with INTEGER columns.
Also, an AUTO_INCREMENT column must be defined as a key. So, try:
CREATE TABLE test (id_pk INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY);
G'luck,
Peter
--
I am not the subject of this sentence.
---------------------------------------------------------------------
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
