8 replies to this topic

[famer]

mySQL
how combine 2 tables with equal structures?

[Stu]

what do you mean combine? you mean transfer the data from one table into another?

i dont know if there is a quicker way but i would just download a backup of the whole database and take the relevant section containing the info for the 2nd table and run the query on the 1st table.

[Chaos King]

The more complicated automated way would be to run a loop taking out all the data from one table and during that loop, insert it into the other table with the nested fields.

[famer]

I mean join, i just think that mysql have a command for it.
ok i'll do it with a script.
thanx

[saferwaters]

It does...its like:

SELECT * FROM table1, table2 WHERE table1.field = table2.field

Or so...and the table1.field MUST be the same as table2.field...such as most tables have an ID column.

[Mr. Matt]

no the code u want is :

Quote

SELECT `colums` INTO `new_tbl_name` FROM `tables` WHERE `table1.id` = `table1.id`;

[rc69]

If he wants to select stuff from multiple tables at once, then darth's code is right.
Since i don't know much about SELECT INTO, i can only assume that would select everything from `tables` and paste it into the `new_tbl_name`.

So depending on what needs to be done, you both may be correct. My simple suggestion would be to look at the following links, and then bookmark them.
http://dev.mysql.com...sql-syntax.html
http://www.w3schools.../sql_select.asp

[Mr. Matt]

well darths is just selecting from tables. Farmer wanted to combine two tables, and u can select multiple tables with the SELECT INTO, then u just make the new table and then u can delete the others after.

[famer]

great!
thanx