in reply to Sybase to MySQL
Sybase: SET rowcount 10 SELECT column FROM table [download]
MySQL: SELECT column FROM table LIMIT 10 [download]