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:http://forums.mysql.com/read.php?20,576325,576325
Thank you for your time. Please help!