/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 vote198 views1 answer
What is in condition in sql
SQL
0 vote243 views1 answer
Like and not like together in sql
SQL
5 votes250 views3 answers
Sql server utc to local
SQL
3 votes205 views1 answer
Sql multi column index performance
SQL
1 vote189 views1 answer
Group_concat max length mysql
SQL
0 vote221 views1 answer
Sqlcmd no headers
SQL
0 vote218 views1 answer
SQL Server date literal
SQL
1 vote252 views1 answer
Wherein mysql
SQL
3 votes208 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote222 views1 answer
Pgadmin save data greyed out
SQL