/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 vote143 views1 answer
Sql server list user permissions
SQL
0 vote162 views1 answer
Like date sql server not working
SQL
1 vote166 views1 answer
Oracle drop job if exists
SQL
0 vote105 views1 answer
Plsql trigger insert update
SQL
0 vote164 views2 answers
Mysql insert into multiple tables
SQL
10 votes190 views1 answer
Oracle all_dependencies
SQL
3 votes186 views2 answers
Brew restart mysql
SQL
4 votes158 views1 answer
SQL find text in SP
SQL
0 vote162 views1 answer
Mysql changer nom table
SQL
0 vote171 views1 answer
Postgresql print variable
SQL