/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 vote198 views1 answer
Firebird where
SQL
1 vote173 views1 answer
Minus vs intersect in sql
SQL
10 votes202 views6 answers
Mysql delete duplicates
SQL
0 vote211 views1 answer
Mysqli_connect using prepare statement
SQL
10 votes196 views6 answers
Sql between
SQL
0 vote197 views1 answer
Postgres select from values
SQL
0 vote199 views2 answers
How to get last inserted id in sql server c#
SQL
25 votes246 views5 answers
Mysql replace text
SQL
2 votes190 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote179 views1 answer
Stuff in sql server
SQL