/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

7 votes102 views1 answer
Sql management studio display line numbers
SQL
0 vote107 views1 answer
Sql case sttement with set
SQL
7 votes108 views2 answers
What is sql clause
SQL
0 vote108 views1 answer
Sql with example
SQL
0 vote127 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote115 views1 answer
Google cloud sql postgres url example
SQL
51 votes319 views6 answers
Installing mysql on ubuntu
SQL
0 vote109 views1 answer
Php mysqli install
SQL
0 vote118 views1 answer
Can we rollback data that are deleted using DELETE
SQL
1 vote103 views1 answer
Adding a default constraint to an existing column in sql
SQL