Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql replace empty string with null

UPDATE
    TableName
SET
    column01 = CASE column01 WHEN '' THEN NULL ELSE column01 END
Comment

PREVIOUS NEXT
Code Example
::  
Sql ::  
::  
:: sqlalchemy _in array sqlite 
Sql ::  
::  
Sql ::  
Sql ::  
:: sql check 
::  
::  
:: select where sql 
Sql ::  
Sql :: increase space oracle aws instance 
Sql :: how to use 3 fields as primary key in sql tables? 
:: oracle activate program 
::  
::  
:: sort by 
::  
Sql ::  
::  
:: how to create a new shema using query languaage 
Sql ::  
::  
::  
::  
Sql ::  
Sql ::  
Sql ::  
ADD CONTENT
Topic
Content
Source link
Name
6+1 =