Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql replace empty string with null

UPDATE
    TableName
SET
    column01 = CASE column01 WHEN '' THEN NULL ELSE column01 END
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #mysql #replace #empty #string #null
ADD COMMENT
Topic
Name
6+3 =