I did 'handler table_name read limit large_numbers'. Is there a way I can use lower number, but automatically loop through the number and display all of the table records? Thanks.
If "large_numbers" is the number of rows in the table, then of course it will consume a lot of memory and would make it the equivalent to a Select statement. To use Handler properly you need 2 loops. The outer loop would be executing the Handler statement to get the Next 10000 rows. Then the inner loop goes through those 10,000 rows and exports them to the other table. You exit the loop when you get EOF. So you only have 10,000 rows in memory at one time (or however many you want to process at a time). You need some sort of programming language to write the code to do the looping. You can't do this sort of looping at the MySQL prompt I'm afraid.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
