How do you add three minutes to a date?

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

(Continued from previous question...)

How do you add three minutes to a date?

ADDDATE(techinterviews_publication_date, INTERVAL 3 MINUTE)

(Continued on next question...)

Other Job Interview Questions

• How MySQL Opens and Closes Tables
• Explain the difference between MyISAM Static and MyISAM Dynamic.
• MySQL - What issues should I be aware of when setting up two-way replication?
• How do you start and stop MySQL on Windows?
• Privileges Provided by MySQL
• MySQL - What should I do to prepare my client code to use performance-enhancing replication?
• What does myisamchk do?
• MySQL - What issues should I be aware of when setting up two-way replication?
• What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
• Functionality Missing from MySQL - Sub-selects
• More...