Best way to update a large DB ?

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: http://li

Best way to update a large DB ?

> 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 integ

Re: char as word boundary

On 6/13/2022 12:13 PM, Mark Waddingham via use-livecode wrote: Hypercard and livecode 6.7:  the number of chars (numtochar(32)& numtochar(202)&numtochar(32)& numtochar(202)&numtochar(32)) = 2 livecode 9.67  :   the number of chars (numtochar(32)& numtochar(202)&numtochar(32)&

Re: char as word boundary

"dirty hack" is my middle name! :-) Bob S > On Jun 13, 2022, at 09:13 , Mark Waddingham via use-livecode > wrote: > > This was primarily a very dirty hack (which was done before my time!) ___ use-livecode mailing list use-livecode@lists.runrev.co

Re: Best way to update a large DB ?

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

Re: char as word boundary

Hi Jean-Jacques, On 2022-06-03 14:56, Jean-Jacques Wagner via use-livecode wrote: Hi, Version 6.7word boudary are char number 09,10,11,12,13,32 version 9.67 word boudary are char number 09,10,11,12,13,32,202 Hypercard and livecode 6.7: the number of chars (numtochar(32)& numtochar(202)&nu

Re: Best way to update a large DB ?

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 following

Best way to update a large DB ?

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, bec