/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 votes340 views1 answer
Oracle number to percentage
SQL
0 vote336 views1 answer
Date diff sql
SQL
1 vote339 views1 answer
How refresh navicat tables to see new tables
SQL
27 votes374 views5 answers
Mysql set password for user
SQL
0 vote374 views1 answer
What alter does in db
SQL
0 vote367 views2 answers
Nosqlbooster query other collection
SQL
18 votes353 views3 answers
Mysql current date
SQL
13 votes396 views2 answers
Oracle select into and inner join
SQL
5 votes341 views2 answers
Oracle timestamp to date
SQL
0 vote368 views4 answers
Rownum in sql
SQL