> I am very new to Mysql. I have searched several mailing list for the
> answers I need and read the manual but cannot find the answer to a very
> basic question........
> I am using Mysql 3.22.20 and Redhat 5.2 with latest version of perl.
> The problem I have is trying to update a table with data from another
> Table1 is the main data table called products, are some of the fields
> Table 2 is a temorary table where I insert a raw data file, manipulate it
> and when finished want to insert it into table 1(products) but only want to
> overwrite(replace) the price field if the code already exists.
> I have tried the following to see if the code already exists, but get an
> error saying the client is out of memory
> :--- SELECT * FROM products,table2 WHERE products.code<>table2.code ;
> I have also tried the following
> :--- SELECT * FROM products,table2 WHERE NOT products.code=table2.code ;
> Can somebody please advise the best way to update 1table with the data from
replace into my_table select ...
make sure to use unique keys. More details in the