This is a post about
CURRENT_TIMESTAMP() functions in MySQL.
Firstly, note is that of these three, only
CURRENT_TIMESTAMP() is part of the SQL Standard.
NOW() happens to be an alias for
CURRENT_TIMESTAMP() in MySQL.
Secondly, note that replication does not work well with non-deterministic functions. And “hey, what time is it?” is non-deterministic. Ask it twice, with a second apart between asking, and both times you get different results (with at least second precision).
You can start to see the problem here….but there’s more…. (more…)