/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

6 votes151 views2 answers
Clear a table in mysql
SQL
0 vote122 views1 answer
Plpgsql if statement
SQL
-1 vote164 views1 answer
Brisanje dupliranih konatakata
SQL
16 votes138 views2 answers
Sql vs nosql
SQL
0 vote126 views4 answers
How to get max salary in each department in sql
SQL
0 vote124 views2 answers
Postgres show current role
SQL
1 vote128 views1 answer
DATE_SUB postgres
SQL
0 vote162 views2 answers
How to prevent sql injection in java
SQL
6 votes115 views2 answers
How to copy data in sql
SQL
0 vote120 views2 answers
How to delete the rows with null values in mysql
SQL