/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 vote326 views1 answer
How to check rollback status in oracle
SQL
0 vote367 views1 answer
How to check common records in 2 table
SQL
0 vote575 views1 answer
Power bi connect to postgresql
SQL
0 vote280 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote272 views1 answer
Search db for table name
SQL
0 vote291 views2 answers
Mysql unique two columns
SQL
0 vote297 views1 answer
Mysql query to select the highest value
SQL
0 vote315 views2 answers
Mysql show foreign keys
SQL
0 vote347 views1 answer
Mysl like insert a variable
SQL
0 vote291 views1 answer
Get db connection detail from sql developer profile
SQL