phpmyadmin Question posted in
The official documentation can be found here.

Checking several tables when updating table – Phpmyadmin

I am trying to create a script, which will update column lang_id in table static if static.method_id = methods.method_id and if methods.mm_id = languages.mm_id and if languages.is_default = 1. But this one is not working, tell me please, why?

UPDATE s
SET s.lang_id = IFNULL(l.lang_id,1)
FROM static as s
JOIN methods as m
ON m.method_id = s.method_id
JOIN languages as l
ON m.mm_id = l.mm_id AND l.is_default = 1

upd. I am using MySQL
Getting error in

'FROM merchants__payment_methods_static as s
JOIN merchants__payment_methods as '

That’s what phpMyAdmin tells me

Tags:

2

Answers


  1. 0

    Incidentally, in MySQL, the following is syntactically correct:

    UPDATE static as s
JOIN methods as m
ON m.method_id = s.method_id
JOIN languages as l
ON m.mm_id = l.mm_id AND l.is_default = 1
SET s.lang_id = COALESCE(t.lang_id,1);
    Login or Signup to reply.
  2. 0

    Use LEFT joins:

    UPDATE static s
LEFT JOIN methods m ON m.method_id = s.method_id
LEFT JOIN languages l ON m.mm_id = l.mm_id AND l.is_default
SET s.lang_id = COALESCE(l.lang_id, 1);
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search