/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

19 votes328 views5 answers
Change column name mysql command line
SQL
52 votes566 views6 answers
Rename column sql
SQL
1 vote334 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote343 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote387 views1 answer
Sql datum formatieren
SQL
0 vote309 views1 answer
Wordpress sql change site url
SQL
0 vote319 views1 answer
Mysql query single row
SQL
0 vote309 views1 answer
Dns slave zone convert
SQL
11 votes334 views1 answer
Get ddl materialized view oracle
SQL
0 vote331 views1 answer
Mysql query to check record exists in database table or not
SQL