ryc writes:
> I have a auto increment field in a table and after doing a few operations
> the flag has gone away. This is using mysql 3.23.36 on OpenBSD. Here is how
> it happened:
>
> I am using perl with DBI to interface with mysql. I have been inserting
> "NULL" into this field to allow mysql to fill in the auto_increment value
> for me. Eventually I started using mysqlimport to put records into this same
> table. When the text file had "NULL" for the auto_increment field,
> mysqlimport would count that as a warning. Wanting to get mysqlimport to run
> warning free I tried changing the values from NULL to 0 for the
> auto_increment field. This worked great.
>
> Sometime a week later, and many many imports, I changed the perl code to
> insert with 0 instead of "NULL". Instead of working as advertised, the
> insert resulted in a row with id set to "0" rather than the next
> auto_increment value. I deleted the row with id 0, and tried running
> mysqlimport again only to find it will not insert anything because of
> duplicate key entry "0" (even though it has been deleted). I ran myisamchk
> and it said the table was fine. After running myisamchk I noticed the extra
> column does not list "auto_increment" when doing a "describe table". It just
> went away.
>
> When I try to do "select * from table where id = 0" I get error 127,
> record-file is crashed.
>
> Does anyone know how I can fix this without loosing any data or changing the
> values in the auto_increment field? Did I do something wrong to screw up the
> table? How can this be avoided in the future?
>
> Thanks in advance.
> ryan
Hi!
The only solution for your problem in this moment is to omit
auto_increment column add list of columns in mysqlimport.
We plan to make a more flexible import in 4.* .
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
