/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

2 votes298 views2 answers
Sql first character
SQL
0 vote315 views1 answer
The package java.sql is not accessible
SQL
23 votes298 views4 answers
Sql server substring
SQL
0 vote253 views1 answer
Delete all rows from table sqlite
SQL
0 vote274 views1 answer
Postgresql copy backup table
SQL
0 vote293 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
4 votes296 views1 answer
Create db table
SQL
0 vote298 views1 answer
Alter fedora mysql 8.0 user
SQL
4 votes300 views1 answer
Wildcard in sql
SQL
18 votes299 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL