你即將離開本站

並前往https://bytes.com/topic/mysql/answers/898785-mysql-how-use-update-if-else-condition

How to use UPDATE with IF-ELSE condition - MySQL Database

UPDATE elec_products SET; `status` = IF(programname='Argos', 1, IF(programname='sify', 2, 3) ); WHERE programname IS NOT NULL. Oct 16 '10.

確定！ 回上一頁

查詢 「MySQL UPDATE if」的人也找了：

  1. Mysql update if select
    2.
  2. MySQL update if else
    3.
  3. MySQL update if NULL
    4.
  4. MySQL UPDATE if
    5.
  5. Mysql update case when
    6.
  6. Mysql update by condition
    7.
  7. MySQL UPDATE syntax
    8.
  8. MySQL IF
    9.