What’s the difference between Unix timestamps an

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

(Continued from previous question...)

What’s the difference between Unix timestamps and MySQL timestamps?

Internally Unix timestamps are stored as 32-bit integers, while MySQL timestamps are stored in a similar manner, but represented in readable YYYY-MM-DD HH:MM:SS format.

(Continued on next question...)

Other Job Interview Questions

• How do you change a password for an existing user via mysqladmin?
• How would you select all the users, whose phone number is null?
• When would you use ORDER BY in DELETE statement?
• What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
• Functionality Missing from MySQL - Stored Procedures and Triggers
• How do you find out which auto increment was assigned on the last insert?
• MySQL - Speed of UPDATE Queries
• How MySQL Uses Memory
• MySQL - Speed of DELETE Queries
• MySQL - Running MySQL in ANSI Mode
• More...