/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 vote225 views1 answer
Mariadb case switch
SQL
2 votes233 views2 answers
Convert_tz mysql
SQL
0 vote228 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote215 views1 answer
Select max salary from each department in sql
SQL
0 vote234 views1 answer
Oracle procedure teamplate
SQL
0 vote225 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote230 views1 answer
Pl/ sql change currency
SQL
2 votes228 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote178 views1 answer
Check if due date is less than todays date sql
SQL
2 votes176 views1 answer
Oracle current date without time
SQL