/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 vote160 views1 answer
Reset postgresql password windows
SQL
0 vote132 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
27 votes137 views5 answers
Add column in table
SQL
0 vote117 views0 answer
SQL
6 votes156 views2 answers
Mysql timestamp to date
SQL
1 vote153 views1 answer
Drop primary key oracle
SQL
0 vote147 views2 answers
Py sqlite if entry exists
SQL
0 vote160 views1 answer
Mysql order by where condition sub query
SQL
0 vote142 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
5 votes131 views1 answer
Sql select ciunt
SQL