Delete or Update on Import

Once each day I have a PHP application that reads a legacy dBase format file and updates a customer table in a MySQL database. The PHP script reads each dBase record, searches for it in the table, updates the field values if they have changed, or creates a new record in the MySQL database if one do

Re: Writing to Local Files

On Tue, 07 Sep 2004 15:08:30 -0500, gerald_clark wrote: > > Tim McDonough wrote: > >> Is there a way to write the results of a query to an output file >> on a client computer instead of the server? My reference book >> says MySQL cannot write to a file on the client. >

Writing to Local Files

Is there a way to write the results of a query to an output file on a client computer instead of the server? My reference book says MySQL cannot write to a file on the client. I have a work around by using a PHP script on the user's machine that does a MySQL query, formats the results, and writes

Replication with Different OS

Our MySQL database server currently runs on a Win32 platform. If we setup replication do the slaves have to also run on Win32 or can a slave be a different platform such as Linux? Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Better Solution than Multiple Queries?

I have an application where I want to look for records that match certain criteria and then for each item found do a second lookup for additional information. Normally I would do a join. In this case however I want to display each of the results from the first of the two criteria whether or not the

Re: How to optimize ugly order by?

On Wed, 24 Mar 2004 15:47:46 +0100, Henrik Schröder wrote: > I have a table of users which contains a lot of information, and > also a column called membershiptype which can either be 0, 1, or 2. > This table is used a lot in various searches, and all results > should be ordered by membership type

Re: Finding Most Recent Record for Sensor Problem Solved

On Tue, 09 Mar 2004 00:41:19 -0500, Michael Stassen wrote: > Did anyone refer you to the following page in the manual? > > > I admit to feeling a little foolish here. My "solution" came from combining a couple of similar query for

Finding Most Recent Record for Sensor Problem Solved

The other day I was looking for a way to find only the most recent piece of data stored in a historical database of 40 sensors. Thanks for all the helpful suggestions. While no one suggested a fully working solution the suggestions got me pointed in the right direction. In case anyone might be lurk

Re: Re: Selectinmg most recent dates from multiple table items

g from each of the 40 sensors. > On Saturday 06 March 2004 07:22 pm, Tim McDonough wrote: > This seems similar to something I'm working on which I haven't > sorted out to my satisfaction yet. > > We have a system that collects and stores data that is time > stamped in

Selectinmg most recent dates from multiple table items

On Sat, 06 Mar 2004 20:40:24 -0600, Paul DuBois wrote: > > You can use your LIMIT clause as well, as long as by that you don't > mean "5 most recent from *each* table". > This seems similar to something I'm working on which I haven't sorted out to my satisfaction yet. We have a system that colle