MySQL Forums
Forum List  »  Newbie

Re: Replace existing data base
Posted by: Shay _Fox
Date: January 26, 2016 01:39PM

Rick James Wrote:
-------------------------------------------------------
> It might be worth researching why you have so many
> numbers. Do you have that many rows? Or have you
> deleted a lot of row? Or have a lot of numbers
> 'vanished'? There are many causes for
> `AUTO_INCREMENT` numbers being "burned". If that
> is your case; let's discuss it.
>
> REPLACE
> INSERT IGNORE
> ROLLBACK
> ...


agreed with you Rick there are many causes for Auto_INCREMENT numbers being "burned".

Options: ReplyQuote


Subject
Written By
Posted
January 25, 2016 02:27PM
January 26, 2016 12:30AM
Re: Replace existing data base
January 26, 2016 01:39PM


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.