/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 vote150 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote188 views1 answer
Download mysql database to excel in android studio
SQL
0 vote152 views1 answer
Sqlite update only if greater
SQL
-1 vote156 views1 answer
Ssql to lowercqse
SQL
2 votes164 views1 answer
Mysql time ago difference
SQL
0 vote152 views1 answer
How to select only a certain date sql
SQL
11 votes152 views4 answers
Query DISTINCT
SQL
0 vote167 views1 answer
How to check default value of column in sql server
SQL
0 vote160 views1 answer
Mysql timediff
SQL
0 vote183 views1 answer
How to enable mysql 5.7 root user password on linux
SQL