/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

4 votes247 views2 answers
DB::transaction
SQL
0 vote247 views1 answer
Fetch second word from a string in ms sql
SQL
18 votes257 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote279 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote269 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote271 views1 answer
Postgresql auto increment not working
SQL
0 vote263 views1 answer
Oracle last connexion
SQL
1 vote256 views1 answer
Sql current timestamp
SQL
2 votes271 views1 answer
Sql OR
SQL
13 votes289 views3 answers
Mysqldump structure only
SQL