How do you concatenate strings in MySQL?

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

(Continued from previous question...)

How do you concatenate strings in MySQL?

CONCAT (string1, string2, string3)

(Continued on next question...)

Other Job Interview Questions

• How to connecting to the MySQL Server
• MySQL - When Privilege Changes Take Effect
• Functionality Missing from MySQL - Foreign Keys
• What Have We Used MySQL For?
• What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)
• MySQL Command Interpreter
• How would you delete a column?
• MySQL - Speed of DELETE Queries
• Functionality Missing from MySQL - How to Cope Without COMMIT/ROLLBACK
• MySQL - When Privilege Changes Take Effect
• More...