/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

8 votes159 views2 answers
Phpmyadmin password
SQL
11 votes173 views1 answer
Ddl materialized view
SQL
1 vote179 views1 answer
Get create table query existing table mysql
SQL
0 vote165 views2 answers
Mysql disable foreign key checks
SQL
0 vote683 views1 answer
T sql less than date
SQL
0 vote165 views1 answer
Case when with count and combining similar values in sql
SQL
-1 vote183 views1 answer
Adding a new table psql
SQL
-1 vote207 views1 answer
Create view in mysql workbench
SQL
1 vote185 views1 answer
Sql select whole row max column
SQL
34 votes218 views6 answers
Install mysql client ubuntu
SQL