/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 vote383 views1 answer
Mysql 8 geo to json
SQL
0 vote349 views1 answer
Provera dupliranih konatakata
SQL
-1 vote380 views5 answers
Operator in sql
SQL
54 votes577 views6 answers
Sql rename column
SQL
3 votes366 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote356 views1 answer
Prepared statement mysql java delete selected rows
SQL
-1 vote339 views1 answer
Mysql coalesce
SQL
-1 vote355 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote350 views1 answer
Mysql replication change database name
SQL
0 vote362 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL