/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 vote255 views1 answer
How to get table id sequence postgres
SQL
0 vote203 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote230 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote163 views1 answer
Oracle compile schema
SQL
2 votes226 views5 answers
SQL trigger
SQL
18 votes196 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
-1 vote215 views3 answers
SQL to LINQ converter
SQL
1 vote224 views1 answer
Mysql breakline on string
SQL
0 vote230 views1 answer
Implicit inner join table alias
SQL
0 vote241 views1 answer
Rows, INSERT INTO, Returning
SQL