4. What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

Answer

TIMESTAMP column is updated with Zero when the table is created.  UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to  current time whenever there is a change in other fields of the table.

All Mysql Questions
Ask your interview questions on mysql

Write Your comment or Questions if you want the answers on mysql from mysql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---