/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 vote115 views1 answer
Executescalar in sql server
SQL
0 vote113 views1 answer
New rails app with mysql
SQL
0 vote89 views1 answer
Compare field sql server
SQL
3 votes103 views2 answers
Oracle sql truncate table
SQL
0 vote109 views4 answers
Sql server date format yyyy-mm-dd
SQL
27 votes108 views4 answers
Get all tables with column name sql
SQL
1 vote103 views1 answer
Pgsql sum switch case
SQL
1 vote121 views1 answer
How to see all table partition in oracle
SQL
6 votes156 views2 answers
Database url postgres
SQL
9 votes99 views3 answers
Where in sql
SQL