But what if you really want to store the timesta

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

(Continued from previous question...)

But what if you really want to store the timestamp data, such as the publication date of the article?

Create two columns of type TIMESTAMP and use the second one for your real data.

(Continued on next question...)

Other Job Interview Questions

• MySQL - SQL Commands Related to Replication
• How to Make MySQL Secure Against Crackers
• MySQL - How the Privilege System Works
• How do you get a portion of a string?
• What does tee command do in MySQL?
• On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?
• MySQL - System/Compile Time and Startup Parameter Tuning
• MySQL - User Names and Passwords
• MySQL - When Privilege Changes Take Effect
• MySQL is Portability
• More...