DBA > Job Interview Questions > MySQL and SQL

Explain data type TIMESTAMP DEFAULT CURRENT_TIME

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

(Continued from previous question...)

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

The column exhibits the same behavior as a single timestamp column in a table with no other timestamp columns.

(Continued on next question...)

Other Job Interview Questions