How to set the timestamp with microseconds as default value?

  • @zenith, do you believe in the correctness of microseconds in modern OS? - avp
  • @avp is actually the need for microseconds in the database has already disappeared, after editing the code, but the question itself is interesting. - zenith

2 answers 2

Well, judging by the changelog version 5.6.4, you can ...
bug old and famous

Noted in 5.6.4 changelog.

MySQL now supports fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microsecond precision.

No MySQL does not support microsecond storage. But you can create your own date-time format.