Re: chunking a blob field. adding a large object chunk by chunk
| From: | Marek Kilimajer | Date: | Tue, 31 Dec 2002 11:35:19 +0000 |
| Subject: | Re: chunking a blob field. adding a large object chunk by chunk | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-129759@lists.php.net to get a copy of this message | ||
You could do
UPDATE table SET blob_field = CONCAT(blob_field, '$next_chunk')
but I'm not sure if your sql server will not read the whole field into memory anyway.
Mike Brancato wrote:
if I wanted to read a very large object into a blob field, is there a way i could do it in 1MB chunks. using and UPDATE statement "field = field+'$data'". and just use fread to read 1MB at a time into $data. -- Mike Brancato