/SQL/Mysql default timestamp value to be current timestamp

Mysql default timestamp value to be current timestamp

CURRENT_TIMESTAMP

You can use two timestamp in one table. For default, use DEFAULT field first 
and then the rest timestamp fields.

Below query should work.

CREATE TABLE myTable 
(
 id INT,
 date_registered TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
 date_validated TIMESTAMP
);

Similar codes

0 vote370 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote174 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
2 votes169 views1 answer
Check isolation level in mysql
SQL
3 votes180 views1 answer
Oracle get trigger ddl
SQL
0 vote180 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote159 views1 answer
Join creating duplicate columns sqllite
SQL
-1 vote189 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote172 views1 answer
Sql change primary key to composite key
SQL
0 vote129 views1 answer
Mysql collation for all languages
SQL
6 votes168 views2 answers
Can't connect to local mysql server through socket
SQL