/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

11 votes124 views2 answers
MySQL DISTINCT
SQL
0 vote125 views1 answer
Postgresql not in alternative
SQL
0 vote110 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote134 views1 answer
MySQL import data from large CSV file
SQL
0 vote121 views1 answer
Oracle session statistics
SQL
2 votes132 views1 answer
Oracle percentage
SQL
0 vote115 views1 answer
Coalesce for comma separated in sql server
SQL
5 votes119 views1 answer
How to check port number for postgresql
SQL
3 votes115 views2 answers
WhereIn SQL
SQL
1 vote129 views2 answers
Sql drop multiple columns if exists
SQL