Posts by Felype • 101 points

• 0

  votes

  2

  answers

  1648

  views

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

  You can try to create a function: DELIMITER ;; CREATE FUNCTION obterSeconds (horaini INT, diaini INT, mesini INT, seconds INT) RETURNS INT BEGIN RETURN CASE WHEN (mesini = MONTH(NOW()) AND diaini =…

  mysql sql-update

  answered 9 years, 3 months ago Felype 101