Try LIMIT in the select
Plamen Slavov wrote:
> Hi guys,
> I have a big MySQL table - about 300MB
> I want to get all the records from the table, make certain transformations and write
>them to a text file (i can not use "select into outfile...)
> the problem is when i type "select * from <table name>" the server hangs
> is there a way that i can select 1 record at a time or something similar, which
>would not put so much pressure on the server, but i still will get every record from
>the table
> Thanks
> ----------------------------------------------------------------------------------
> Visit our site at http://eshop.bg
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
