/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

1 vote193 views1 answer
Mysql count multiple columns in one query
SQL
0 vote154 views1 answer
Connection error in mysql workbench
SQL
4 votes190 views2 answers
Sql vs mysql
SQL
3 votes190 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
8 votes209 views1 answer
Declare table variable sql server
SQL
0 vote208 views2 answers
Dumping sql table
SQL
50 votes261 views6 answers
Sql duplicate rows
SQL
0 vote201 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
4 votes180 views1 answer
Sql group by year
SQL
1 vote199 views2 answers
Snowflake alter column data type
SQL