tinytext has no default after restoring db
I backup my databases daily with mysqldump --all-databases.
After losing a hard drive, and reinstalling MySql, I loaded the databases from the backup SQL file.
Now I get the following error on some inserts :
java.sql.SQLException: Field 'foo' doesn't have a default value
A 'describe' of the table shows these fields with a default value of NULL.
They were created as tinytext NOT NULL.
Subject
Views
Written By
Posted
tinytext has no default after restoring db
2018
October 23, 2015 06:43AM
1136
October 25, 2015 12:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.