/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 vote191 views1 answer
Partition by sql server
SQL
0 vote186 views2 answers
Psql commande \gset
SQL
0 vote175 views1 answer
Mysql select all where count more than"
SQL
0 vote195 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
1 vote182 views1 answer
Sql count value greater than
SQL
1 vote185 views1 answer
How to use a trigger to validate input data
SQL
0 vote166 views1 answer
Mariadb LOAD DATA INFILE
SQL
3 votes184 views2 answers
Oracle apex charging debug
SQL
0 vote177 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote183 views1 answer
PGSQL dynamic table name
SQL