Answers for "mysql created_at datetime default 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
);

Posted by: Guest on April-23-2021

Code answers related to "mysql created_at datetime default current_timestamp"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql created_at datetime default current_timestamp"

Code answers related to "mysql created_at datetime default current_timestamp"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql created_at datetime default current_timestamp"

Code answers related to "mysql created_at datetime default current_timestamp"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us