mysql replace empty field with NULL

You can do this command:

update your-table-name set your-column-name=NULL where length(your-column-name)=0;

In this way all “empty” columns get “NULL” value.