|Latest Version: 1.0||Copyright © 2003, Ross A. Beyer|
mysql_coldiff Usage: mysql_coldiff [-v] [-d <database>] [-i <index column>] [-c <column_equivalences>] [-n] [-u <MySQLTM username>] [-p <MySQLTM password>] [-h <MySQLTM host>] <from_table> <to_table>
This program is designed to connect to a MySQLTM server and compare the information in the two tables requested. This program uses the comparison operators in MySQLTM itself, but still may take some time with large tables. Similarly, the two databases should have comparable structures.
If invoked without any arguments, a brief message will be displayed. This program shows the differences in the data between two tables, the <from_table> and the <to_table>. In order to figure out how to compare the two tables, a column in each table must be specified as the <index column> to join on.
These two table arguments can be specified with the MySQLTM format of 'database.table.index_column', where the 'index_column' element is the column to join the two tables on. These table arguments can have one to three elements separated by periods.
If the database is not specified in the table argument, then the default database specified by the -d option will be used. Similarly, if an index_column is not specified in the table argument, the value of the -i option will be used. If the -i option isn't specified, then the program will try to use the index_column name from the other table argument as the index_column name. Similarly, values specified in the table arguments override values specified by -d or -i.
|Last Updated: 12 Oct 2003|