先上SQL UPDATE customer SET remarks = ( CASE WHEN IFNULL( remarks, '' ) = '' THEN '' ELSE remarks END ) WHERE remarks IS NULL SQL详解