distal-attribute
distal-attribute
distal-attribute
distal-attribute

ON UPDATE CURRENT_TIMESTAMP stays selected

User, date Message
Written by joe
4 months ago
Category: General
1 posts since Wed, 02 Apr 14
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.