记录一下MYSQL的SQL语法

这是加时间的语法

update  mylog set  mydate= DATE_ADD( mydate, INTERVAL 13 HOUR) WHERE mydate BETWEEN '2014-03-01 00:00:00' AND '2014-03-01 23:59:59'

原文地址:https://www.cnblogs.com/redmondfan/p/3576674.html