Mysql WorkBench: varchar default value as empty

Question

Before I started using MySql WorkBench, I used phpmyadmin and loved setting default values ​​for varchars to empty. Therefore, in my code, I would not need to check for null values ​​and use it only if the $ value = '' comparison. How to set default value as empty in mysql workbench? If I leave the text field empty, unlike phpmyadmin, it seems to me that I do not want the default value.

Thank you

Imran

Answer 1

Just put two quotation marks '' in the default field for your column.

Or right click on the column and select Default ''

Answer 2

There is an error in Workbench that does not allow updating an empty line (it says no changes). I set it to the field first, '' and then changed the sql code to an empty string. '' It does the trick.