You wrote a search engine that should retrieve 1

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

(Continued from previous question...)

You wrote a search engine that should retrieve 10 results at a time, but at the same time you’d like to know how many rows there’re total. How do you display that to the user?

SELECT SQL_CALC_FOUND_ROWS page_title FROM web_pages LIMIT 1,10; SELECT FOUND_ROWS(); The second query (not that COUNT() is never used) will tell you how many results there’re total, so you can display a phrase "Found 13,450,600 results, displaying 1-10". Note that FOUND_ROWS does not pay attention to the LIMITs you specified and always returns the total number of rows affected by query.

(Continued on next question...)

Other Job Interview Questions

• MySQL - Replication Implementation Overview
• How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
• What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id)
• MySQL - Using Your Own Benchmarks
• How would you change a column from VARCHAR(10) to VARCHAR(50)?
• MySQL - Reasons NOT to Use Foreign Keys constraints
• How MySQL Stores Its Row Data and Index Data?
• How do you start and stop MySQL on Windows?
• MySQL - Why So Many Open tables?
• What is DDL, DML and DCL?
• More...