Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .

Answers were Sorted based on User's Feedback



Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ...

Answer / prasanna shejwal

TIMESTAMP DEFAULT :- when new row get inserted or existing
row get updated that time current timestamp get inserted.

CURRENT_TIMESTAMP :- when row get inserted that time current
timestamp get inserted. No change on update.

ON UPDATE CURRENT_TIMESTAMP :- when row get updated that
time current timestamp get inserted. On inserted default
value get inserted

Is This Answer Correct ?    9 Yes 0 No

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ...

Answer / 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

More MySQL Interview Questions

Restore database (or database table) from backup.

0 Answers  


what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

10 Answers   E2 Solutions, Tesco,


How do I start mysql database?

0 Answers  


How do I use mysql?

0 Answers  


How To see all the tables from a database of mysql server.

0 Answers  






What tools available for managing mysql server?

0 Answers  


What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

0 Answers  


What is mysql uuid?

0 Answers  


In which language it is written?

0 Answers  


What is mysql default port number?

0 Answers  


Is mariadb faster than mysql?

0 Answers  


Do I need python for mysql?

0 Answers  


Categories