Posts by Manuel Martins • 11 points

• 1

  votes

  2

  answers

  1648

  views

  Q: Mysql UPDATE multiple fields under the same condition (IF or CASE)

  Friends, I need help. I have these two darlings: UPDATE leilaov SET seconds = CASE WHEN (mesini = MONTH(NOW()) AND diaini = DAYOFMONTH(NOW()) AND horaini = HOUR(NOW()) AND minutoini <=…

  mysql sql-update

  asked 9 years, 7 months ago Manuel Martins 11