Re: UPDATE from one server to another

2006-06-06 Thread Jason Dimberg
Daniel da Veiga wrote: On 6/6/06, Jason Dimberg [EMAIL PROTECTED] wrote: I am working on an application where data will be collected on laptops and then uploaded to a central database once the laptop is able to connect to the network after being in the field. I was initially thinking of using

UPDATE from one server to another

2006-06-05 Thread Jason Dimberg
I am working on an application where data will be collected on laptops and then uploaded to a central database once the laptop is able to connect to the network after being in the field. I was initially thinking of using MS Access as a front end with linked tables through MySQL ODBC. I am

Re: Fun with Dates and Incentives.

2006-05-24 Thread Jason Dimberg
I think doing a sort by date with limit 10 should get you the first ten. I believe the now() function uses the server time, so no need to do date/time calcs really. Good luck, Jason Brian Menke wrote: I'm hoping for some general advice on an approach for the following scenario: I have

AlterTable Structure Across Multiple DBs

2006-03-30 Thread Jason Dimberg
across multiple dbs as opposed to editing each one individually? In retrospect I should have combined them into one db and may consider doing that. All dbs start with 'pm_' and have identically named tables MySQL 5.0.18 Windows 2003 Thank you, -- *Jason Dimberg* -- MySQL General Mailing List

Re: deleting rows in 2 tables

2005-10-09 Thread Jason Dimberg
Rhino wrote: - Original Message - From: Merlin [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, October 09, 2005 1:31 PM Subject: deleting rows in 2 tables Hi there, I am wondering if there is a possiblity to delete rows in more than one table with one query. At the