/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 vote197 views1 answer
Mysql find db contarint
SQL
2 votes221 views1 answer
How to delete columns in sql
SQL
0 vote227 views1 answer
How to join result table in mysql
SQL
0 vote208 views2 answers
Mysql add days to date
SQL
0 vote200 views2 answers
How to type a blank discord messgae
SQL
-1 vote198 views3 answers
Check table exist postgresql
SQL
6 votes202 views2 answers
Mysql get yesterday
SQL
0 vote212 views1 answer
Mysql update set sum
SQL
10 votes216 views2 answers
Mysql alter add foreign key
SQL
0 vote235 views1 answer
Wp_query raw sql
SQL