Default value for TEXT type in MySQL

TEXT type in MySQL cannot have a default value.
We can use trigger to get a default value when a new record is inserted:

create trigger
before insert on lists for each row set NEW.customfield='';


Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows

Fixed: ImportError: No module named