Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44?

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

(Continued from previous question...)

Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP.

A default value is used on initialization, a current timestamp is inserted on update of the row.

(Continued on next question...)

Other Job Interview Questions

• How would you change a table to InnoDB?
• Functionality Missing from MySQL - How to Cope Without COMMIT/ROLLBACK
• What are CSV tables?
• MySQL is Portability
• How to Make MySQL Secure Against Crackers
• What’s the difference between CHAR_LENGTH and LENGTH?
• Functionality Missing from MySQL - How to Cope Without COMMIT/ROLLBACK
• MySQL - Disk Issues
• What are HEAP tables in MySQL?
• Functionality Missing from MySQL - Foreign Keys
• More...