Hi. I'm converting a database from a filesharing based technology to mySQL. The database has its own column type called Sequence which is the same as using the AUTO_INCREMENT property. I'd like to use AUTO_INCREMENT if possible but I'm not really sure what I can do with it - can anybody help with the following:
1. How does LAST_INSERT_ID() work? Can I find out the last ID I created on a specific table and will this return the correct value if multiple users are inserting into the tables? 2. I need to import data into the tables and do not want mySQL to re-create the ID values for these records. How can this be achieved? Cheers. Kev ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --------------------------------------------------------------------- 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
