What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Easy way to copy data from one database table to another

Easy way to copy data from one database table to another
Author: Message:
MeEtc
Patchou's look-alike
*****

Avatar
In the Shadow Gallery once again

Posts: 2200
Reputation: 60
38 / Male / Flag
Joined: Nov 2004
Status: Away
O.P. Easy way to copy data from one database table to another
Needing some SQL help here. I'm trying to find an easier way of creating a query that will take values from a row on one table, and insert the data onto another. Most of the field names are the same, save a few.
What I want to know, is if there's an easier way than using a SELECT on the first table, saving the data to variables/an array, and using an INSERT on the second table.

I have attached a structure dump of the tables in question

Any suggestions?

.txt File Attachment: structure.txt (5.2 KB)
This file has been downloaded 131 time(s).

This post was edited on 01-14-2008 at 05:08 PM by MeEtc.
[Image: signature/]     [Image: sharing.png]
I cannot hear you. There is a banana in my ear.
01-14-2008 05:03 PM
Profile PM Web Find Quote Report
WDZ
Former Admin
*****

Avatar

Posts: 7106
Reputation: 107
– / Male / Flag
Joined: Mar 2002
RE: Easy way to copy data from one database table to another
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
01-14-2008 05:08 PM
Profile PM Web Find Quote Report
markee
Veteran Member
*****

Avatar

Posts: 1622
Reputation: 50
36 / Male / Flag
Joined: Jan 2006
RE: Easy way to copy data from one database table to another
You can always export out of PHPMyAdmin and import it into the new one 8-)
[Image: markee.png]
01-14-2008 08:28 PM
Profile PM Find Quote Report
MeEtc
Patchou's look-alike
*****

Avatar
In the Shadow Gallery once again

Posts: 2200
Reputation: 60
38 / Male / Flag
Joined: Nov 2004
Status: Away
O.P. RE: Easy way to copy data from one database table to another
a php page can't do that on its own though
[Image: signature/]     [Image: sharing.png]
I cannot hear you. There is a banana in my ear.
01-14-2008 08:30 PM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On