Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .

Answer Posted / amith

The column exhibits the same behavior as a single timestamp
column in a table with no other timestamp columns.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql_pconnect?

461


What is mysql database extension?

474


How many tables we can create in mysql database?

490


How to run 'mysql' commands from a batch file?

490


What are the column comparisons operators?

619






If we use sum function in mysql, does it return sum of that row or for that column?

526


Explain triggers and stored procedures?

494


What is root password?

473


How to write after insert event update trigger on the same table in mysql?

500


How do I change the max connection in mysql?

513


Is mysql owned by oracle?

535


Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

458


What is mysqli_result?

503


How does select query work?

489


What is mysql vs sql?

483