MySQL Forums
Forum List  »  Stored Procedures

Diff or compare two tables
Posted by: Mark Vancura
Date: August 16, 2013 01:45PM

I will be implementing a basic version management system for tables contributed by my users, and need to know if one of their tables has changed anything or not compared to the version in the vault. A "diff" function or compare function is integral to this, but I can't seem to find one in version version 5.6.13-standard.

I have found I can copy a table with a command like:
create table DB_Vault."Port_descriptions:102" select * from Port_descriptions ;
So copy required me to look at create table.

But I need to know if "Port_descriptions:101" and test.Port_descriptions differ
or not. How can I determine that? These are not very big tables: 517 rows.
I have been considering update and triggers, but there is no proof of concept there for me yet.

Any better ideas?

Options: ReplyQuote


Subject
Views
Written By
Posted
Diff or compare two tables
5101
August 16, 2013 01:45PM
1650
August 16, 2013 02:52PM
1650
August 16, 2013 03:29PM
1307
August 17, 2013 02:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.