J S wrote:
Hi,
I want to copy data from one table to another. However I need to do this carefully because I haven't got much of space left. I was thinking of maybe selecting data from every 100000 rows of the old table, inserting it into the new table, then deleting those rows from the old table.
This will not free up the disk space used by those 100000 rows.
Could someone help me out with the SQL for this please? Or tell me if there's a better way of doing this?
Thanks,
JS.
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
