on select statements

[Yemi Obembe]

what is the difference between this:

SET @a=1; PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?';EXECUTE STMT USING
@a;

and this:
'SELECT * FROM tbl LIMIT 1

And then this:

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

and this:
'SELECT * FROM tbl LIMIT 1,5