A default value is used on initialization, a current timestamp is inserte

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP.

Question Posted / amith

Answer Posted / amith

A default value is used on initialization, a current
timestamp is inserted on update of the row.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is 1nf 2nf 3nf?

983

What is mysql server?

1081

What is the insert?

886

How can you plan the logshipping before processing?

2339

How can you filter the duplicate data while retrieving records from the table?

894

What is mysql architecture?

1006

How to store values to array from mysql database in php?

944

How can you create and drop view in mysql?

927

What does it mean to be case sensitive?

1001

Which is better mysql or microsoft sql?

922

Do while loop in mysql procedure?

1072

Why we use mongodb instead of mysql?

968

What is mysql and why it is used?

1084

How do I view tables in mysql workbench?

916

What is back end and front end?

905