qq_35482582的博客

原创 mysql数据库里的时间字段,如何不变动年月日,只改时分秒

需求是把policy_info表内的policy_end_time字段的时分秒都改成'23:59:59',年月日不变下图是policy_info表内的policy_end_time字段(timestamp类型),用Navicat打开的先是几个查询,可忽略select count(*) from policy_info where RIGHT(policy_end_time,8) = '23:59:59';select count(*) from policy_info where...