/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 vote331 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
6 votes419 views2 answers
Oracle compile trigger
SQL
0 vote314 views0 answer
SQL
0 vote345 views1 answer
How to change null display in psql
SQL
0 vote306 views1 answer
Jooq finding lastest value in table
SQL
0 vote317 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote370 views1 answer
Oracle string length
SQL
2 votes331 views1 answer
Possgress drop if exists table
SQL
0 vote329 views1 answer
Turn on foreign keys check mysql
SQL
0 vote342 views1 answer
Convert rows to columns in sql server
SQL