/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 vote148 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote176 views1 answer
Oracle call a function in a insert statement
SQL
11 votes184 views6 answers
Distinct sql
SQL
0 vote183 views1 answer
Less than and between in sql query
SQL
0 vote168 views1 answer
Mysql percentage of total
SQL
3 votes172 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
2 votes179 views1 answer
Sql ignore accents
SQL
1 vote188 views2 answers
Sql server concat string and int
SQL
0 vote165 views1 answer
Java spring boot connect to sql server
SQL
0 vote177 views1 answer
Create a view in sqlite
SQL