SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Compare 2 tables
-
Mar 5, 2001, 17:09 #1
- Join Date
- Aug 2000
- Location
- Silicon Valley
- Posts
- 2,241
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hi,
How do you compare 2 tables? (see if they're identical or not - if not, which field/row)
Thanks- Son Nguyen
AdSpeed.com - Ad Serving and Ad Management Made Easy
-
Mar 7, 2001, 11:08 #2
- Join Date
- Jun 2000
- Location
- Sydney, Australia
- Posts
- 3,798
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I can't think of any short-cut way of doing that. I mean its completely illogical that a database would have two tables that are identical
I can only think that you would need to put the contents of the tables into arrays and just step through the arrays comparing each elemet
-
Mar 7, 2001, 16:22 #3
- Join Date
- Apr 2000
- Posts
- 1,483
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Or you could find a text editor/program that does comparisons (eg Beyond Compare is an excellent one, not sure of URL though). Then dump the two tables to seperate text files and compare those?
Bookmarks