MySQL Forums
Forum List  »  InnoDB

Re: Auto increment value get set to ' 18446744073709551615 ' with multiple load data infile
Posted by: Rick James
Date: August 13, 2013 11:19PM

http://en.wikipedia.org/wiki/Wheat_and_chessboard_problem

OK, seriously. It is what happens when you put -1 into a BIGINT UNSIGNED field.

Well, that may not explain how you got it in the table.

Or what to do about it...

ALTER TABLE foo AUTO_INCREMENT=17455787100;
(That's 1 more than 17455787099; not sure if "one more" is required, but should not hurt.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Auto increment value get set to ' 18446744073709551615 ' with multiple load data infile
797
August 13, 2013 11:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.