2009/7/19 mviamari <[email protected]>: > > I need to keep the existing 'id' from the backup data file so that the > FK relationship remains intact. Has anyone seen a problem like this > before and/or have a solution? >
Which RDBMS you are use? For MySQL, you can try: ALTER TABLE `sales` AUTO_INCREMENT = 10000; -- XUE Can --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
