/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

1 vote267 views1 answer
Can not connect to mysql server
SQL
-1 vote240 views1 answer
Oracle db list usernames
SQL
0 vote288 views1 answer
Logtash mysql cofiguration file
SQL
0 vote274 views1 answer
How to get table current identity value in sql server
SQL
1 vote312 views1 answer
Homebrew install mysql
SQL
1 vote269 views2 answers
End mysql command
SQL
0 vote285 views4 answers
Convert databse to achieve log mode oracle
SQL
13 votes289 views2 answers
Sql online compiler
SQL
0 vote267 views1 answer
Mysql command prompt date insert format
SQL
0 vote268 views1 answer
Hive batch drop table
SQL