/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 votes262 views1 answer
Select nextval from sequence sql
SQL
2 votes250 views1 answer
Username sql
SQL
0 vote278 views1 answer
Openquery update linked server
SQL
0 vote256 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote266 views2 answers
Enter into postgresql database,create user and grant Access
SQL
5 votes239 views2 answers
Create table
SQL
1 vote263 views1 answer
Raw query must include primary key
SQL
1 vote240 views1 answer
Foreign key constraint in ms sql
SQL
0 vote217 views1 answer
Sql select rows with simlar names
SQL
0 vote269 views2 answers
Disadvantages of stored procedures sql
SQL