/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 vote181 views1 answer
Oracle sql assign unique number to each grouping
SQL
1 vote193 views2 answers
Check if word is in column sql
SQL
3 votes172 views2 answers
Oracle sql truncate table
SQL
3 votes189 views1 answer
Show index table
SQL
1 vote178 views1 answer
Select statement to print longest name
SQL
0 vote179 views1 answer
Oracle archivelog usage
SQL
8 votes232 views6 answers
Insert command in sql
SQL
8 votes187 views1 answer
Sql remove leading spaces
SQL
0 vote187 views1 answer
Mysql backup certain tables workbench
SQL
2 votes188 views2 answers
Run mysql command from bash
SQL