u011306408的博客

记录一些常用的函数一，更新当前时间mysql:update sys_user set update_data =sysdate() where id=#{id}db2:update sys_user set update_data =TO_CHAR(current timestamp,'YYYY-MM-DD HH24:MI:SS') where id=#{id}二，IFNULL() 函数mysql:select ifnull(batchNo,1) from sys_inputbatch