how many maximun number of row can fetch from mysql using php mysql for mysqli

<?php
$query = mysql_query("select * from emp");
// emp table contain 10000 records
while($fetch = mysql_fetch_array($query))
{
     echo fetch[0];
}
/* how many record i can get easily from local mysql server and from localhost as well */
?>

If emp table contain 10000 records, how many record i can get easily from local mysql server and from localhost as well.