Posts by Rodolpho Picoli Gagno • 61 points

• 5

  votes

  3

  answers

  1926

  views

  A: How do you know how many days are in the current month?

  In this context it would use two functions, the CURDATE() to know the date of the day and the LAST_DAT() which returns the last day of the month from a date. SELECT LAST_DAY( CURDATE() ) as DIAS_MES…

  mysql sql date

  answered 8 years, 3 months ago Rodolpho Picoli Gagno 61

• 1

  votes

  2

  answers

  54

  views

  A: Error while running a Trigger

  I didn’t understand the context of the use of Trigger, but analyzing only the code I realized the following. After the INSERT you are updating the field is_new = 0 of the registration you have just…

  mysql trigger

  answered 8 years, 3 months ago Rodolpho Picoli Gagno 61