/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 vote285 views1 answer
Mysql update from select on same table
SQL
0 vote275 views1 answer
How to input data as id in database sql c#
SQL
0 vote271 views1 answer
Dump multiple tables mysql
SQL
1 vote284 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote337 views1 answer
ALV GRID events
SQL
1 vote256 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote276 views1 answer
Plsql check for string in numeric
SQL
2 votes311 views1 answer
Drop all foreign key constraints mysql
SQL
1 vote287 views1 answer
Oracle drop job if exists
SQL
3 votes286 views3 answers
Order by postgres
SQL