I have table – config.
config_name | config_value
And I would like to update multiple records in one query. I try like that:
UPDATE config SET t1.config_value="value" , t2.config_value="value2" WHERE t1.config_name="name1" AND t2.config_name="name2";
but that query is wrong 🙁
Can you help me?