What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?



What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?..

Answer / amith

On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More MySQL Interview Questions

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

0 Answers  


What is mysql optimization?

0 Answers  


What is the diff. bwt. primary key and unique key?

4 Answers  


How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  


what are the optimization techniques for Query optimization performance issues and faster execution of queries

2 Answers   Infosys, Sierra Atlantica,


I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  


How to set mysql variable in php?

0 Answers  


How to use regular expression in pattern match conditions?

0 Answers  


How do you start MySQL on Linux?

5 Answers   Cybernet,


How do I tune a mysql query?

0 Answers  


How do I transfer data from one database to another in mysql?

0 Answers  


Explain the difference between MyISAM Static and MyISAM Dynamic?

1 Answers  


Categories