MySQL 5.6.4 and up 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 an older slave that does not:
CREATE TABLE statements
containing columns that have an
fsp (fractional seconds
precision) value greater than 0, replication will fail due
to parser errors.
Statements that use temporal data types with an
fsp value of 0 will work for with
statement-based logging but not row-based logging. In the
latter case, the data types have binary formats and type
codes on the master that differ from those on the slave.
Some expression results will differ on master and slave.
Examples: On the master, the
system variable returns a value that includes a microseconds
fractional part; on the slave, it returns an integer. On the
master, functions that return a result that includes the
current time (such as
UTC_TIMESTAMP()) interpret an
argument as an
fsp value and the
return value includes a fractional seconds part of that many
digits. On the slave, these functions permit an argument but
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices