I've had a poke around MySQL.com, and Google.com to see if there is an option like this in MySQL. Basically, I need to transfer a record from one table, and place it into another table.
I could do this the long way, and grab all the data via a while {} , and then do a long winded INSERT, but I'm hoping there is an easier way to do it. I've never really had need to do this until now....so TBH, I really don't have a clue where to start on Google/MySQL.com
Thanks for any pointers.
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
I could do this the long way, and grab all the data via a while {} , and then do a long winded INSERT, but I'm hoping there is an easier way to do it. I've never really had need to do this until now....so TBH, I really don't have a clue where to start on Google/MySQL.com
Thanks for any pointers.
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Copying from one table to another...