Find a SQL statement, please help!

maxwax

I need to modify a column of time type data in the table. For example, there is a category in the table that is the date of birth, and all those in the table born in 1982 are changed to 1981. Dateadd can be used in Sql Server, but this function is not available in MySql. Hope you all help. Thank you!

sulfuresser

Try
mysql> select DATE_ADD('1998-01-30', Interval 1 YEAR);

lajx626

Use UPDATE table name SET column name = new value WHERE condition not work, I am also a rookie, don't laugh

haocici

update tablename set Date of Birth = Date_ADD(Date of Birth, INTERVAL -1 YEAR) where Year(Date of Birth) = 1982