You're viewing a single thread.
79
comments
BEGIN
UPDATE
SELECT
COMMIT
And you can save a bunch of time by inlining all this into one query
Why update before select? Shouldn't it be the other way around? (I'm clueless. )
The select after the update is to check if the update went through properly. You can have more selects before the update if you wanted to.
Ah. It makes sense now. Thanks.
The four horsemen of the datapocalypse
Permanently Deleted
You've viewed 79 comments.