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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does mysql support sequence?

507


Is mysql relational database?

481


What is definer in mysql trigger?

498


What is delimiter $$?

506


Is oracle better than mysql?

477






Does mysql scale well?

507


How to returns the columns and column information pertaining to the designated table.

575


Can mysql store files?

502


What are features of mysql?

482


What is a definer?

479


Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

553


How do I rename a table in mysql workbench?

505


How to list or view all databases from the mysql server.

543


How can we convert between Unix & MySQL timestamps?

473


What is difference between unix timestamp and mysql timestamp?

541