Re: [GHGLUG] Have questions about MySQL

From: Michael C.
Sent on: Thursday, December 20, 2012 7:00 AM
Hi Michael,

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.

Thanks,
Mike


On Wed, Dec 19, 2012 at 8:03 PM, Michael Kat. <[address removed]> wrote:
Hello all,

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!

Contact Me




--
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]

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy