/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

0 vote318 views4 answers
Stored procedure sql
SQL
2 votes307 views1 answer
Oracle find unusable indexes
SQL
0 vote317 views1 answer
Install sql server in ubuntu 20.04
SQL
1 vote333 views1 answer
SQL query to get all table records count from a database
SQL
5 votes296 views1 answer
List foreign key oracle
SQL
10 votes319 views5 answers
Between keyword in sql
SQL
0 vote308 views1 answer
Get the First and Last Word from a String or Sentence
SQL
2 votes299 views1 answer
Get first 3 letters name in sql
SQL
0 vote310 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote354 views1 answer
Create new table from old table
SQL