/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

12 votes242 views1 answer
Psql drop column
SQL
0 vote251 views2 answers
While mysql
SQL
20 votes228 views2 answers
Counting in sql
SQL
5 votes252 views2 answers
Sql constraint check value in list
SQL
1 vote233 views1 answer
Deleting database in sql
SQL
0 vote231 views1 answer
Get week day name sql server
SQL
1 vote242 views3 answers
Getdate function in postgresql
SQL
3 votes258 views1 answer
Start mysql server linux terminal
SQL
1 vote219 views1 answer
How to delete record sql delphi
SQL
0 vote240 views1 answer
Sql query to get contact form 7 fields
SQL