/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 votes343 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote329 views1 answer
Mysql breakline on string
SQL
0 vote254 views1 answer
Oracle sql developer script output limit
SQL
4 votes294 views2 answers
Error loading MySQLdb module.
SQL
0 vote295 views1 answer
Porcentaje sql
SQL
0 vote356 views1 answer
What is metadata in sql
SQL
0 vote345 views1 answer
Add user mysql wordpress
SQL
6 votes292 views2 answers
Can't connect to local mysql server through socket
SQL
3 votes351 views1 answer
Mysql group_concat distinct
SQL
1 vote297 views2 answers
Replace text in sql
SQL