/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

8 votes157 views1 answer
Insert a select statement into a table
SQL
0 vote122 views1 answer
Postgresql isnull with max
SQL
24 votes130 views4 answers
Postgres delete database
SQL
0 vote141 views2 answers
Uninstall postgresql mac
SQL
0 vote123 views1 answer
Mysql add to value
SQL
0 vote129 views1 answer
Dump only data
SQL
0 vote140 views2 answers
Dumping sql table
SQL
2 votes137 views1 answer
Mysql trigger after update
SQL
0 vote143 views1 answer
.sql File Run in PSQL
SQL
0 vote141 views1 answer
SQLServerException.makeFromDatabaseError
SQL