Re: Table Not Updating

[Russel James]

Found the problem, my sql was updating field with 'F' when it should have been 'T', so it was updating all the time.

However, Im still finding the cursor much more faster. It takes around 3.45 secs using the cursor where as the same in a joined SQL statement takes around 201 seconds !!!


Here is the SQL I tried it with.

update customers c
join salesledger s
on c.customerid=s.customerid
and s.duedate < curdate()
and s.balance <> 0
set c.hasoverdueBalance = "T"


Customers has around 2000 rows. SalesLedger 145,000 rows.