OT] how to update 2 values in each of 3000 records in MySQL

Bob Sneidar bobs at twft.com
Wed May 18 11:55:19 EDT 2011


I was under the impression you could only update one record at a time in SQL. Sure you can stack queries together and send them all at once (I guess that would be quicker). Is there a limit on the size of a SQL statement? 

Bob


On May 17, 2011, at 11:56 PM, Terry Vogelaar wrote:

> Whether you change record after record, or 50 in one step, depends on the values. It is certainly possible to write a massive SQL instruction. But it might save your sanity when you change them one by one in a repeat loop, with a much simpler SQL query. However, if those 50 records can be filtered easily, and if they share values, combining might make sense. Hard to say.
> 
> Terry





More information about the use-livecode mailing list