Re: [PHP-DB] Comparing tables

2003-08-26 Thread David Smith
quote who=Ron Allen
 I would like to compare 2 tables in a database to determine which records
 are different!!!  Any clues out there.  Thanks in advance!

You didn't say which DBMS you are using. If you're using a DBMS which
supports INTERSECT (not MySQL), and assuming the two tables have the same
column names and types, you can do this:

  (SELECT * FROM table1) INTERSECT (SELECT * FROM table2)

For MySQL INTERSECT support, monitor this doc:

  http://www.mysql.com/doc/en/TODO_sometime.html

--Dave

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Comparing tables

2003-08-25 Thread Ron Allen
I would like to compare 2 tables in a database to determine which records
are different!!!  Any clues out there.  Thanks in advance!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php