DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

Reply
 
Thread Tools Display Modes
Old 01-07-2010, 12:06 PM   #1
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default 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?
dthomsen8 is offline   Reply With Quote
Old 01-08-2010, 01:26 AM   #2
Bo Aakerstrom
Member
 
Bo Aakerstrom's Avatar
 
Join Date: Mar 2005
Location: Derby,UK
Posts: 1,316
Default

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.

   
__________________
www.boaakerstrom.com
Behance Portfolio
Bo Aakerstrom is offline   Reply With Quote
Old 01-08-2010, 05:30 AM   #3
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default

Quote:
Originally Posted by Bo Aakerstrom View Post
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.
Excellent help! Yes, I am on Windows XP Pro, but I have someone else working on this on Windows 7.
dthomsen8 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP connection to MySQL database john_b Web Site Building & Maintenance 11 01-08-2010 06: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


All times are GMT -8. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.