tableone
a |b| c
--------
a1 | |c1
a2 | |c2
a3 | |c3
tabletwo
a | b
-----
a1|b1
a2|b2
a3|b3
a4|b4
a5|b5
merged
a | b | c
a1| b1|c1
a2| b2|c2
a3| b3|c3
a4| b4|
a5| b5|
So I have the two table and I want to merge them. I tried in phpmyadmin these two options:
INSERT IGNORE INTO tableone SELECT * FROM tabletwo;
REPLACE INTO tableone SELECT * FROM tabletwo;
But both do the same (put one table on another), but I want to merge them. So what query must I use? I hope you understand the the question...
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)