|
|
01-07-2010, 01:06 PM | #1 |
Member
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
|
MySQL database capabilities
I am helping someone else learn PHP and MySQL. I have forgotten much of what I know about those packages, but I know that MySQL is not difficult.
What I want is to compare two MySQL files, looking for matches in a certain key field, and then updating one of them with information from a matching record on the second file. For example, street addresses might be the key, no need for city or state because all are in the same city. After getting the street address matches (maybe with manipulation of the addresses to line up apartment numbers or the like), then to compare names in the files, too. This can be done by putting the names from the second file into the first file, and then making a run on the first file to compare and mark the matches. The difficulty is that MySQL is designed to respond to a web page, not to run the procedural compares I am seeing to do. Any advice? |
01-08-2010, 02:26 AM | #2 |
Member
Join Date: Mar 2005
Location: Derby,UK
Posts: 1,509
|
MySQL Workbench has got Schema Synchronization and Comparison utilities, and it can open large files as well (2Tb + (if your file system is NTFS(if FAT I believe it opens up to 4Gb files))). Haven't tried it on really big files but as there is a free version it might be worth a try.
Runs on a variety of operating systems, just in case you are not on Windows. |
01-08-2010, 06:30 AM | #3 | |
Member
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
|
Quote:
|
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PHP connection to MySQL database | john_b | Web Site Building & Maintenance | 11 | 01-08-2010 07:49 AM |
ACDSee database | john_b | Software | 11 | 09-24-2007 08:15 AM |
Database publishing w/DTP tools? | himalaya | General Publishing Topics | 14 | 08-25-2006 11:41 AM |