/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 vote111 views1 answer
Drop constraint in ms sql
SQL
0 vote123 views1 answer
Pl/pgsql declare variable
SQL
4 votes106 views1 answer
What are the data types in sql
SQL
0 vote121 views4 answers
Sql server date format yyyy-mm-dd
SQL
4 votes123 views1 answer
Mysql ip address data type
SQL
0 vote101 views1 answer
Lister les index d'une table oracle
SQL
3 votes131 views2 answers
How to force truncate a table in mysql
SQL
0 vote158 views1 answer
Tsql cte in a transaction
SQL
0 vote120 views2 answers
Postgresql get long running queries
SQL
1 vote138 views1 answer
Spark sql convert string to date
SQL