Hello.
Think about SELECT... INTO OUTFILE and LOAD DATA INFILE (or mysqlimport utility). If you accept the possibility to run MySQL version 5.0.x beta, you could use FEDERATED storage engine. See: http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html Les Schaffer <[EMAIL PROTECTED]> wrote: > I am working on a MySQL application where laptops will be collecting > data into local MySQL tables, and then once a week they will be > network-connected to a central server where they will "check in" their > new data and "check out" new assignments for data collection. > > given a set of rows in a set of tables on the laptop, is there any nifty > way of grabbing their data and inserting/updating these rows into the > server database, other than to do a SELECT on the local connection and > then turn around and create an INSERT or UPDATE SQL command on the > remote connection with the same data to push data onto server? same for > remote-to-laptop. > > due to the nature of the application, laptops will be working on only a > fraction of the total records on the server, so i can not simply copy > the tables on server onto laptop, nor can i copy tables from laptop onto > server, since other laptops will be checking in data too into the same > tables. > > thanks > > les schaffer > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]