1 2 3 4 5 6 7 8 9
| UPDATE ma_table,
(SELECT config_name,IF(config_name='newest_username','roger',IF(config_name='newest_user_id',250,0)) AS NEWCV
FROM ma_table
WHERE config_name IN ('newest_username','newest_user_id')) AS ADDCV,
(SELECT config_name,IF(config_name='newest_username','40',IF(config_name='newest_user_id',0,0)) AS NEWCV2
FROM ma_table
WHERE config_name IN ('newest_username','newest_user_id')) AS ADDCV2
SET ma_table.config_value=NEWCV, ma_table.age=NEWCV2 WHERE
ADDCV.config_name=ma_table.config_name AND ADDCV2.config_name=ma_table.config_name |
Partager