/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 vote286 views1 answer
Java spring boot connect to sql server
SQL
1 vote318 views1 answer
How to truncate a table in databse
SQL
1 vote348 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote318 views1 answer
Like and not like together in sql
SQL
0 vote350 views1 answer
Mysql bash execute sql file
SQL
0 vote420 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote369 views1 answer
Mysql average from two table
SQL
1 vote377 views1 answer
Postgresql if 0 then 1
SQL
0 vote351 views1 answer
View t-sql mail configuration
SQL
0 vote350 views1 answer
Oracle sql copy table without data
SQL