What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

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

(Continued on next question...)

Other Job Interview Questions

• MySQL - Using Your Own Benchmarks
• What does tee command do in MySQL?
• Explain the difference between BOOL, TINYINT and BIT.
• MySQL - Startup options to mysqld which concerns security
• Explain advantages of InnoDB over MyISAM?
• MySQL - How do I rotate replication logs?
• How do you get the month from a timestamp?
• Functionality Missing from MySQL - SELECT INTO TABLE
• MySQL - How do I rotate replication logs?
• How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
• More...