/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 vote183 views1 answer
Datatables server side filter where clause
SQL
1 vote188 views1 answer
Oracle select first row order by
SQL
9 votes153 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote155 views1 answer
Sql group by error
SQL
0 vote161 views1 answer
Search db for table name
SQL
0 vote160 views2 answers
Postgresql get long running queries
SQL
1 vote219 views1 answer
Oracle create program if not exists
SQL
3 votes169 views1 answer
Force using index plsql
SQL
0 vote167 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote178 views1 answer
Mysql conf.d exampel
SQL