Kangkam
Kamis, Juli 01, 2010
MySQL : Merge two tables
using phpMyAdmin :
select database
create new table (note that the new table should have the same structure as the table that we want to merge)
go to the SQL menu and type in the sql box :
INSERT IGNORE
INTO table_1
SELECT *
FROM table_2
;
doh !
source :
http://stackoverflow.com/questions/725556/how-can-i-merge-two-mysql-tables
0 comments:
Posting Komentar
Posting Lebih Baru
Posting Lama
Beranda
Langganan:
Posting Komentar (Atom)
0 comments:
Posting Komentar