<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Apparently yes since there still only one default timestamp</div><div class=""><a href="http://stackoverflow.com/questions/267658/having-both-a-created-and-last-updated-timestamp-columns-in-mysql-4-0" class="">http://stackoverflow.com/questions/267658/having-both-a-created-and-last-updated-timestamp-columns-in-mysql-4-0</a></div><div class=""><br class=""></div><div class="">In Mariadb doc: <a href="https://mariadb.com/kb/en/mariadb/timestamp/" class="">https://mariadb.com/kb/en/mariadb/timestamp/</a></div><div class=""><ul start="1" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(51, 51, 51); font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 14px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 20px; widows: 1; background-color: rgb(255, 255, 255);" class=""><li style="box-sizing: border-box; font-size: 13px;" class="">In <a href="https://mariadb.com/kb/en/what-is-mariadb-55/" style="box-sizing: border-box; color: rgb(61, 98, 255); text-decoration: none; background-color: transparent;" class="">MariaDB 5.5</a> and before there could only be one TIMESTAMP column per table that had CURRENT_TIMESTAMP defined as its default value. This limit has no longer applied since <a href="https://mariadb.com/kb/en/what-is-mariadb-100/" style="box-sizing: border-box; color: rgb(61, 98, 255); text-decoration: none; background-color: transparent;" class="">MariaDB 10.0</a>.</li></ul><div class="">In mysql 5.6: <span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13px; widows: 1; background-color: rgb(255, 255, 255);" class="">The order of the clauses does not matter </span></div></div><div class=""><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class=""><a href="http://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html" class="">http://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html</a></span></div><div class=""><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">To specify automatic properties, use the </span><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; font-family: 'Courier New', Courier, fixed, monospace; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;">DEFAULT CURRENT_TIMESTAMP</code><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class=""> and </span><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; font-family: 'Courier New', Courier, fixed, monospace; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;">ON UPDATE CURRENT_TIMESTAMP</code><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class=""> clauses in column definitions. The order of the clauses does not matter. If both are present in a column definition, either can occur first. Any of the synonyms for</span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_current-timestamp" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">CURRENT_TIMESTAMP</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class=""> have the same meaning as </span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_current-timestamp" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">CURRENT_TIMESTAMP</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">. These are </span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_current-timestamp" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">CURRENT_TIMESTAMP()</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">, </span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_now" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">NOW()</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">, </span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_localtime" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">LOCALTIME</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">, </span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_localtime" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">LOCALTIME()</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">,</span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_localtimestamp" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">LOCALTIMESTAMP</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">, and </span><a class="link" href="http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_localtimestamp" style="box-sizing: inherit; margin: 0px; padding: 0px; font-size: 13.3488px; vertical-align: baseline; text-decoration: none; color: rgb(0, 116, 163); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 12.6814px; vertical-align: baseline; text-decoration: underline; color: black; font-family: 'Courier New', Courier, fixed, monospace; background-color: transparent; background-position: initial initial; background-repeat: initial initial;">LOCALTIMESTAMP()</code></a><span style="color: rgb(85, 85, 85); font-family: 'Open Sans', Arial, Helvetica, sans-serif; font-size: 13.3488px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: 23.3604px; widows: 1; background-color: rgb(255, 255, 255);" class="">.</span></div><div class=""><br class=""></div><div class="">The best is to try but I don’t have mysql < 5,7</div><div class=""><br class=""></div><div class="">/Vincent<br class=""><div><blockquote type="cite" class=""><div class="">On 03 Sep 2016, at 22:10, PICCA Frederic-Emmanuel <<a href="mailto:frederic-emmanuel.picca@synchrotron-soleil.fr" class="">frederic-emmanuel.picca@synchrotron-soleil.fr</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Hello vincent,<br class=""><br class="">is it compatible also with mysql < 5,7 ?<br class=""><br class="">Cheers<br class=""><br class="">Fred</div></div></blockquote></div><br class=""></div></body></html>