/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

3 votes148 views1 answer
Oracle user quota on tablespace
SQL
0 vote130 views1 answer
Hibernate xml property MySQL url, username and password
SQL
-1 vote136 views1 answer
Sql add column bit
SQL
2 votes135 views2 answers
Created at and updated at in mysql
SQL
2 votes150 views2 answers
How to run postgresql in linux
SQL
0 vote132 views1 answer
Access refused mysql xampp server
SQL
0 vote144 views1 answer
Oracle archivemode
SQL
22 votes140 views4 answers
Mysql reset auto increment id
SQL
0 vote148 views1 answer
Postgresql custom order by
SQL
0 vote140 views1 answer
Mysql sql.gz
SQL