Get Rows which are updated in new table compared to old table -SQL

Question

I have a table as

id  Description Tag
1       ABC         Tag1
2       DEF         Tag2
3       ABC         Tag1
4       ABC         Tag1
5       GHI         Tag3
6       DEF         Tag2

and whenever i need to make multiple changes I will create a new table and change the values (tag column). I need a query to get the rows where the tag column has a different value compared to old table.

I removed the incompatible database tags. Please tag with the database you are really using. — Gordon Linoff, Feb 07 '17 at 11:33
You may write trigger to achieve this functionality,On After Update event on that specific old table. — Sagar Gangwal, Feb 07 '17 at 11:42
what you need excatly...create new table or use mysql trigger? — denny, Feb 07 '17 at 11:53

score 0 · Accepted Answer · answered Feb 07 '17 at 12:48

0

I have found the answer to this

select a.id, a.description, a.tag, b.tag
from tableA a, tableB b
where a.tag<>b.tag
and a.id=b.id

answered Feb 07 '17 at 12:48

Manu Mohan

167
3
17

Get Rows which are updated in new table compared to old table -SQL

1 Answers1