/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

1 vote347 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote362 views1 answer
Mysql check table exists
SQL
0 vote350 views1 answer
Mysql root permission denied lost
SQL
0 vote338 views1 answer
Postgres 11 add primary key
SQL
8 votes393 views1 answer
See all users mysql
SQL
1 vote330 views1 answer
Crontab every month
SQL
0 vote342 views1 answer
Placements hackerrank solution
SQL
0 vote374 views1 answer
Oracle to_number
SQL
0 vote345 views1 answer
Install sql server windows 10
SQL
0 vote334 views1 answer
Sql query to select records entered in last 24 hours
SQL