/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 vote150 views1 answer
Mysql export search results
SQL
0 vote260 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote157 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote165 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
38 votes221 views4 answers
Count sql
SQL
6 votes169 views1 answer
Identify primary key in oracle table
SQL
8 votes140 views2 answers
Phpmyadmin password
SQL
4 votes189 views1 answer
Rename stored procedure in sql server
SQL
0 vote159 views1 answer
Sql combine results from two tables
SQL
0 vote151 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL