# MySQL - TIMESTAMP Default value should use MODIFY instead of ALTER

**URL:** <https://forum.liquibase.org/t/mysql-timestamp-default-value-should-use-modify-instead-of-alter/3978>\
**Category:** Liquibase Development\
**Created:** [May 22, 2018, 12:13pm UTC](https://forum.liquibase.org/t/mysql-timestamp-default-value-should-use-modify-instead-of-alter/3978 "2018-05-22T12:13:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Xu11](https://avatars.discourse-cdn.com/v4/letter/x/b77776/32.png) [@Xu11](https://forum.liquibase.org/u/Xu11)\
**Post date:** [May 22, 2018, 12:13pm UTC](https://forum.liquibase.org/t/mysql-timestamp-default-value-should-use-modify-instead-of-alter/3978/1 "2018-05-22T12:13:00Z")

</div>

```

```

This is actually wrong syntax.

My suggestion:&nbsp;ALTER TABLE short\_video.short\_video **MODIFY** COLUMN created\_at **timestamp** DEFAULT CURRENT\_TIMESTAMP();

— This will make not only infomix ([document](http://www.liquibase.org/documentation/changes/add_default_value.html)) but also MySQL should require&nbsp;3.4.2
