MySQL Error in multiple table UPDATE

Question

Here is my query:

UPDATE TBL_LABELS SET TMP.column_value = LBL.label_desc, TMP.info_value=LBL.helptext
       FROM TBL_LABELS TMP
       INNER JOIN hh_label_mast LBL ON TMP.column_name=LBL.lbl_id
       WHERE page_id in(as_page_id ,'HHGENPGID')
       AND lang_cd= as_langcd;

While executing this I am getting an error like "right syntax to use near FROM TBL_LABELS TMP INNER JOIN hh_label_mast LBL ON TMP.column_name=LBL.lbl_"

Can you please give me the right syntax?

Daniel Vassallo · Accepted Answer · 2010-08-02 10:22:19Z

4

There shouldn't be a FROM clause in the UPDATE syntax. You may want to try:

UPDATE      tbl_labels TMP
INNER JOIN  hh_label_mast LBL ON (TMP.column_name = LBL.lbl_id)
SET         TMP.column_value = LBL.label_desc, 
            TMP.info_value = LBL.helptext
WHERE       page_id IN(as_page_id ,'HHGENPGID') AND lang_cd = as_langcd;

edited Aug 2, 2010 at 10:22

answered Aug 2, 2010 at 10:13

Daniel Vassallo

346k72 gold badges513 silver badges447 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Error in multiple table UPDATE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related