merge query in mysql

[barrathi]

hai all,

how to merge the two table( i need query)

ex:
table a

eno ename
1 a
2 b


table b

eno ename

3 c
4 d


i need result like
table b

1 a
2 b
3 c
4 d

i need uppend the data(update)


help me.

thanks & regards
munibarrathi.p

[ronverdonk]

Since you don't give any information on keys or what to do with duplicates, the basic statement for this is the INSERT statement

INSERT INTO table_b SELECT eno, ename FROM table_a;

Ronald :cool:

[barrathi]

Since you don't give any information on keys or what to do with duplicates, the basic statement for this is the INSERT statement

INSERT INTO table_b SELECT eno, ename FROM table_a;

Ronald :cool:

Hi ronald,

iam asking
oracle merge query:( i need like this type of query in mysql)
---------------------------

merge into tablename2 a
using tablename1 b
on (a.eno=b.eno)
when matched
then update
set a.ename=b.ename
where a.eno=b.eno
when not matched
then insert (eno,ename)
values (80,'ram');


if any possible tell me

thakns in advance

barrathi

[barrathi]

Since you don't give any information on keys or what to do with duplicates, the basic statement for this is the INSERT statement

INSERT INTO table_b SELECT eno, ename FROM table_a;

Ronald :cool:

hi ronald,

iam asking merge query i want to update the table(uppend)

if i have a two table

table1:
---------

1 a

2 b

table 2
---------
3 c

4 d


i want to uppend the table

result like

1 a
2 b
3 c
4 d

in oracle merge query

merge into tablename2 a
using tablename1 b
on (a.eno=b.eno)
when matched
then update
set a.ename=b.ename
where a.eno=b.eno
when not matched
then insert (eno,ename)
values (80,'ram');


like this in mysql i need

if possible tell me

thanks
barrathi

[ronverdonk]

MySQL does not have a MERGE query, so you'll have to split it into 2 queries.

Ronald :cool:

[Motoma]

You could do a similar thing with a UNION, but it would not modify either table.

Here is a simple example:

SELECT 1 AS Col1, 'A' AS Col2
UNION
SELECT 2 AS Col1, 'B' AS Col2
 

[barrathi]

hi

thanks for your information

regards
barrathi