How would you change a column from VARCHAR(10) t

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

(Continued from previous question...)

How would you change a column from VARCHAR(10) to VARCHAR(50)?

ALTER TABLE techinterviews_questions CHANGE techinterviews_content techinterviews_CONTENT VARCHAR(50).

(Continued on next question...)

Other Job Interview Questions

• MySQL - Speed of UPDATE Queries
• What does + mean in REGEXP?
• What Have We Used MySQL For?
• How do you offload the time/date handling to MySQL?
• MySQL - What the Privilege System Does
• How do you concatenate strings in MySQL?
• MySQL - How do I upgrade on a hot replication setup?
• Explain the difference between MyISAM Static and MyISAM Dynamic.
• MySQL - Startup options to mysqld which concerns security
• How would you change a column from VARCHAR(10) to VARCHAR(50)?
• More...