What does this query mean: SELECT user_name, use

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

(Continued from previous question...)

What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)

It’s equivalent to saying SELECT user_name, user_isp FROM users LEFT JOIN isps WHERE users.user_id=isps.user_id

(Continued on next question...)

Other Job Interview Questions

• General Information About MySQL
• What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
• How do I find out all databases starting with ‘tech’ to which I have access to?
• What is the difference between mysql_fetch_array and mysql_fetch_object?
• When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?
• MySQL - What the Privilege System Does
• Explain the difference between MyISAM Static and MyISAM Dynamic.
• The Main Features of MySQL
• MySQL - How do I upgrade on a hot replication setup?
• How do you start and stop MySQL on Windows?
• More...