直接看语句: UPDATE tablename SET num = IFNULL(num,0)+1,createtime=DATE_FORMAT(NOW(),'%Y-%m-%d %T') WHERE id='88888888888'