There several ways to do this. In Oracle I would generally just create a new table and use the INSERT command in the SQL statement to populate the "temp table" and the same thought process also applies to MYSQL
Give me a call if you like, Cell (860)[masked] or Home (860) 621-5999.
On Wed, Dec 19, 2012 at 8:03 PM, Michael Kat. <[address removed]>
I have a few questions about MySQL queries. If you can help me, please reply.
In a nutshell, I am trying to overwrite my table with a temporary one. However, the PRIMARY KEY to be updated is different between the two tables (It has been modified when the table was copied, for a reason).
Can I do an INSERT INTO or a REPLACE INTO query with a PRIMARY KEY reference to be a specific field I pick, other than the one specified for either of the two tables?
More information at the MySQL forum at:
Thank you for your time. Please help!
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Michael Kat. ([address removed]) from Greater Hartford GNU Linux Users Group.
To learn more about Michael Kat., visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages
Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]