|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
January 7th, 2005, 03:40 PM
|
|||
|
|||
|
consolidating tables
hopefully someone here can help me out....I need to transfer all of my records from multiple tables into one table, is there an easy way to do this with out transferring every single record one by one?? I was thinking about dumping the tables and then using update or something to put the dumped records in the new table(I dont exactly know how to actually do that though), all the tables have the same format and number of columns...please help
|
|
#2
January 10th, 2005, 08:01 AM
|
||||
|
||||
|
I usually use a programming language.
I'll develop a script which simply grabs all the data I want from the table and prints out INSERT statements that I can use to make the new table. Its the easiest solution i've used =) not sure if there's any more efficient ones though.
|
|
#3
January 10th, 2005, 05:19 PM
|
|||
|
|||
|
Look over MySQL's INSERT...SELECT functionality; it's used for building queries that fill one table with the contents of others.
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > consolidating tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
