How would you delete a column?

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

(Continued from previous question...)

How would you delete a column?

ALTER TABLE techinterviews_answers DROP answer_user_id.

(Continued on next question...)

Other Job Interview Questions

• What's MySQL
• How MySQL Locks Tables
• What’s the difference between Unix timestamps and MySQL timestamps?
• What does myisamchk do?
• Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
• Functionality Missing from MySQL - Sub-selects
• Functionality Missing from MySQL - SELECT INTO TABLE
• How MySQL Optimizes LIMIT
• What does –i-am-a-dummy flag to do when starting MySQL?
• MySQL - How do I rotate replication logs?
• More...