hi there,
is there a problem with importing data into a table with an auto_increment
field with a primary key, if the data contains values for the auto_increment
field?
I keep getting an error that it can't insert the value "1" more than once.
However, all the values for the auto_increment field are unique (though not
consecutive) - and if I create the table with the field as a normal int,
then the import is successful and all values for the int field are indeed
unique. I could not find anything in the manual describing this behaviour.
I've also tried sending this post with the data file (small) and commands
used but unfortunately it gets rejected by the anti-spam software and 3
attempts later I couldn't work out why, so I hope this is enough information
thanks
dan
---------------------------------------------------------------------
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
