Oh and you can prevent a file transfer from timing out… look up
libURLSetExpect10
Neville
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
> update myDB set col1 = "blah blah", col2 = "blah blah" where id = 12345
> limit 1
> I have a file with all the requests that weights almost 200 Mb.
Unless your "blah blah”s are very large indeed shouldn’t your change data be
packable into a much smaller file to transmit? Eg if they were
If ID is a unique identifier, you should not need the limit. I agree with Mike,
you shouldn't need to do anything fancy. A button and a loop should do it. If
the data is critical, you may want to step through a few loops to verify, or
backup the database first, always a good idea. Nothing worse
and you can't do it locally? that isn't that many records. it shouldn't
take long at all.
On Mon, Jun 13, 2022 at 4:31 AM jbv via use-livecode <
use-livecode@lists.runrev.com> wrote:
> Hi list,
>
> I have a mySQL DB with about 40 entries, and I need to update
> 19 of them in the
Hi list,
I have a mySQL DB with about 40 entries, and I need to update
19 of them in the following way :
update myDB set col1 = "blah blah", col2 = "blah blah" where id = 12345
limit 1
I have a file with all the requests that weights almost 200 Mb.
I can't upload it via phpMyadmin,
