ON UPDATE CURRENT_TIMESTAMP stays selected

[expired user #7950]'s profile image [expired user #7950] posted 10 years ago in General Permalink
If you have ON UPDATE CURRENT_TIMESTAMP selected on a TIMESTAMP field, and then select a different default, the ON UPDATE CURRENT_TIMESTAMP stays selected. This then throws an error when saving because you can't have NULL ON UPDATE CURRENT_TIMESTAMP.

Thanks, this is the most user-friendly SQL manager out there!

Please login to leave a reply, or register at first.