MySQL 8.0 permits fractional seconds for
TIMESTAMP values, with up to
microseconds (6 digits) precision. See
Section 11.3.6, “Fractional Seconds in Time Values”.
There may be problems replicating from a master server that
understands fractional seconds to a slave using a version
earlier than MySQL 5.6 that does not understand them. For
statements containing columns that have an
fsp (fractional seconds precision)
value greater than 0, replication will fail due to parser
errors, and some expression results will differ on master and
slave. Statements that use temporal data types with an
fsp value of 0 will work for with
statement-based logging but not row-based logging. Note,
however, that replicating from a newer master to an older slave
is not a recommended configuration.