Hello guys,

Let say:
UPDATE some_table SET some_field=1 WHERE id = some_id
and
UPDATE some_table SET some_field=0 WHERE id <> some_id

what I can do to merge these queries?
The first thing that came up in my mind was something like that:

UPDATE some_table SET some_field=1 WHERE id = some_id; SET some_field=0 WHERE id
<> some_id;
so we can walk-through table only once...

What do you think?

Regards,
July<a 
href='http://mail.bg/ads/adclick.php?bannerid=875&amp;zoneid=13&amp;source=&amp;ismap='
 target='_blank'><br>
Семестър по сексознание за напреднали!<br>
Спечели 3000 лева в новия конкурс на<br>
http://www.femalelife.bg<br><br>
</a><div id="beacon_875" style="position: absolute; left: 0px; top: 0px; visibility: 
hidden;"><img 
src='http://mail.bg/ads/adlog.php?bannerid=875&amp;clientid=289&amp;zoneid=13&amp;source=&amp;block=0&amp;capping=0&amp;cb=ceb8e5e897af6979fb06b546b520fb00'
 width='0' height='0' alt='' style='width: 0px; height: 0px;'></div>

Reply via email to