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
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| MySQL TIMESTAMP default value | 8 | 4991 | January 10, 2011 | |
| addDefaultValue generates erroneous sql for MySQL | 3 | 579 | February 3, 2011 | |
| auto updating timestamp ? | 6 | 3952 | September 5, 2011 | |
| MySQL GenerateChangeLog | 3 | 393 | December 12, 2009 | |
| How to let "timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" on mysql work in liquibase? | 0 | 908 | June 27, 2011 |