Linux DB PHP Scripts Tech Diary
Search This Blog
Tuesday, February 2, 2010
Cross Table Update with MySQL
update a table with data from another table
UPDATE compounds AS c , excel AS e
SET c.Price_1 = e.price
WHERE c.catalog_no = e.cno;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment