MySQL tips

Here's a quick way to SELECT only a single row (or some other number of rows) from a MySQL table.

SET @skip=x; SET @numrows=y;
PREPARE STMT FROM 'SELECT * FROM table_name LIMIT ?, ?';
EXECUTE STMT USING @skip, @numrows;

where x is the number of rows to ignore and y is the number of row to display

To SELECT only the 10th row:

SET @skip=9; SET @numrows=1;
PREPARE STMT FROM 'SELECT * FROM table_name LIMIT ?, ?';
EXECUTE STMT USING @skip, @numrows;

To SELECT only rows 10 to 12:

SET @skip=9; SET @numrows=3;
PREPARE STMT FROM 'SELECT * FROM table_name LIMIT ?, ?';
EXECUTE STMT USING @skip, @numrows;

To SELECT only rows 20 to 100:

SET @skip=19; SET @numrows=81;
PREPARE STMT FROM 'SELECT * FROM table_name LIMIT ?, ?';
EXECUTE STMT USING @skip, @numrows;

You get the picture....