REPLACE not working
Hello,
I am new to MySQL and am trying to update data in one table with data from another.
SELECT products.products_id,
products.products_quantity,
pos_items.id,
pos_items.quantity
FROM products, pos_items
REPLACE INTO pos_items (id, quantity) VALUES (products_id, products_quantity) WHERE pos_items.id= products.products_id;
I can't figure out what I am doing wrong.
Any suggestions or help will be greatly appreciated.
Thanks, Kevin
Subject
Written By
Posted
REPLACE not working
November 06, 2004 09:38PM
November 12, 2004 09:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.