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=860&amp;zoneid=13&amp;source=&amp;ismap='
 target='_blank'><p>СТАНТЕК - http://www.stantek.com<br/>
компютри за дома и офиса,<br/>
коректно обслужване,<br/>
партньорство и добри цени</p></a><div id="beacon_860" style="position: absolute; left: 
0px; top: 0px; visibility: hidden;"><img 
src='http://mail.bg/ads/adlog.php?bannerid=860&amp;clientid=273&amp;zoneid=13&amp;source=&amp;block=0&amp;capping=0&amp;cb=522e3492978f772735809616c5e107b2'
 width='0' height='0' alt='' style='width: 0px; height: 0px;'></div>

Reply via email to