/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 vote362 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
-1 vote203 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
4 votes214 views1 answer
Adding data to table in sql python
SQL
0 vote203 views1 answer
Sql transact create cursor with dynamic tables
SQL
2 votes206 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
1 vote209 views2 answers
How to search date in sql query
SQL
33 votes186 views2 answers
Postgres how to add field created at
SQL
1 vote204 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
1 vote206 views1 answer
Type int in mysql maxlenght
SQL
1 vote188 views1 answer
Store select query result in variable sql server
SQL