MySQL - TIMESTAMP Default value should use MODIFY instead of ALTER

 

This is actually wrong syntax.

My suggestion: ALTER TABLE short_video.short_video MODIFY COLUMN created_at timestamp DEFAULT CURRENT_TIMESTAMP();

— This will make not only infomix (document) but also MySQL should require 3.4.2