而不是sysdate，请尝试使用CURRENT_TIMESTAMP，例如:

Instead of sysdate, try CURRENT_TIMESTAMP like:

CREATE TABLE foo (
    creation_time      DATETIME DEFAULT   CURRENT_TIMESTAMP,
    modification_time  DATETIME ON UPDATE CURRENT_TIMESTAMP
)