Stefan, The problem look be solved;
i've just changed structure of the updatable table. First this table have only 1 primary key, now my table have some indexed unique keys. and now if i do a replace into command look's like to work fine. I have just a question: i need also to change structure of the master table (have only a primary key) or the changes made on the updatable_table are enough? regards, fabrizio On Fri, 24 Jan 2003 00:10:19 +0100 "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]> wrote: > Fabrizio, > > please send the table structures of table_1 and table_2 (DESCRIBE ...) > so we can do more for you than just guess what the problem might be. > > REPLACE seems good in the first place, but if it just INSERTs then > there's a problem with the (primary) keys. > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > ----- Original Message ----- > From: "Fabrizio Tivano" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, January 23, 2003 5:22 PM > Subject: updating tables > > > > > > hello dear all, > > > > i have a problem updating tables: > > > > in my queries i try to use REPLACE but is same like INSERT command. > > > > ...i need only to refresh table_1 with new entries from table_2. > > > > any ideas? > > > > TIA > > fabrizio > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Fabrizio Tivano WAN System Administrator SAD Trasporto Locale S.p.a. Corso Italia 13/N 39100 BOLZANO e-mail : [EMAIL PROTECTED] Tel: +390471450268 Fax: +390471450253 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php