NULL DEFAULT 'NULL'

T_DeWees

MySQL Compare keeps generating scripts that just don't run for me. It turns columns created as NULL into NULL DEFAULT 'NULL'. Is this a MySQL issue?

KeithK

I'm having the same problem with statements like: MODIFY COLUMN `created_at` timestamp NULL DEFAULT 'NULL';

More info here on my issue: https://forum.red-gate.com/discussion/85969/1067-invalid-default-value/p1?new=1

KeithK

I'm having the same problem with statements like: MODIFY COLUMN `created_at` timestamp NULL DEFAULT 'NULL';

More info here on my issue: https://forum.red-gate.com/discussion/85969/1067-invalid-default-value/p1?new=1