I needed to convert a database from SQL to MySQL and did so successfully, however, this question is more geared towards MySQL now.
I noticed that I'm able to insert
"ON UPDATE CURRENT_TIMESTAMP"
TIMESTAMP data is stored as 4 byte integer denoting number of seconds since Unix epoch. What you see presented in your software is dependent on how your software presents this data. For example, if you change your timezone to different one, it will have an effect on data read from
TIMESTAMP column (beacuse Unix epoch is in UTC)
There will be no mixing of data. MySQL will take care of converting your
YYYY-MM-DD HH:MM:SS into timestamps. Be wary of timezones though!
TIMESTAMP columns, MySQL will by default format them in human readable form, so don't expect to get integers from these. You will get a string formatted in
YYYY-MM-DD HH:MM:SS just like from