MySQL Forums
Forum List  »  General

REPLACE not working
Posted by: Kevin Smith
Date: November 06, 2004 09:38PM

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

Options: ReplyQuote


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.