Posted by Josh McFarlane on 01/11/06 22:28

I've got a structure where I have a database that I want to merge into
another (same format), however, I need to update some fields.

Is it possible to do an INSERT and an UPDATE in the same SQL statement
without modifying the original data with the update statement? (Making
a modification to the recordset in memory that you are inserting)

I'd like to do the following:

Insert data into first new table
Retreive new primary key ID for each record

Pull child records out of second table
Update foreign key to new key from above
Insert records into new table

Thanks in advance!
Darsant

• Next in forum: Re: session information at *some* clients lost
• Prev in forum: Re: MySQL structure synchronization
• Thread view: Possible to copy data and update a field at the same time?

[Reply to this message]