MySQL Features & Bugs

From ISoft Wiki
Revision as of 15:00, 18 December 2018 by Daytonlowell (talk | contribs)
Jump to navigationJump to search
  • Automatic Initialization and Updating for TIMESTAMP and DATETIME: added in 5.6.5 Source
    • Additional Notes:
x INT DEFAULT NULL #works in all versions
x TIMESTAMP DEFAULT NULL #works in some versions, and not in others
x TIMESTAMP NULL DEFAULT NULL #seems to work in all?

This seems like a bug, but it changed between devdb and cloud (so between 5.7.15 and 5.7.24)

  • Virtual/Generated Columns: added in 5.7.9 Source
  • JSON Column Data Type: added in 5.7.8 JSON Data Type: Source