/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

3 votes133 views2 answers
Brew start mysql
SQL
1 vote134 views1 answer
Check message id sql server
SQL
0 vote136 views2 answers
Disallowed function mysql to_date()
SQL
0 vote134 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote130 views1 answer
Pl/sql loop example
SQL
0 vote132 views1 answer
Pip install mysqlclient error
SQL
0 vote114 views2 answers
Android sqlite query join
SQL
0 vote136 views2 answers
Mysql get routine parameter list
SQL
0 vote134 views1 answer
Mariadb cast null to 0
SQL
0 vote174 views1 answer
Update mysql from paypal shopping cart and ipn
SQL