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 :: one to many sql 
Sql :: connect mysql 
Sql :: truncate in oracle sql 
Sql :: Power BI merge tables same columns 
Sql :: postgres where 
Sql :: create domain sql 
Sql :: ranking functions in sql 
Sql :: mysql_union 
Sql :: what is between operator 
Sql :: C# mysql update statement set value to null 
Sql :: SQLSTATE[42S02]: Base table or view not found: 1146 Tabl 
Sql :: sequelize postgresql schema 
Sql :: sql query to linq converter online 
Sql :: if mysql UPDATE 
Sql :: break too long line yaml 
Sql :: make a socket server to detect changes in mysql 
Sql :: ring execute query then print the query result. 
Sql :: sqlalchemy how to use sequence 
Sql :: db connection using sql client in dot net 
Sql :: consulta alias con inner join 
Sql :: influxdb clone measurement 
Sql :: sql server search all databases for objects 
Sql :: sqlalchemy where in query 
Sql :: how to create a new shema using query languaage 
Sql :: get all jobs if salary more than 5500 less than 10000 sql 
Sql :: query for backup a database at another location in file system 
Sql :: What is the library that should import to use all functional database features in SQLite? 
Sql :: mamp mysql config file 
Sql :: database create table date of birth data type 
Sql :: expose db in virtualbox 
ADD CONTENT
Topic
Content
Source link
Name
1+1 =