Hi all,
Thanks for the help.
However I have additional issue with UPDATE statement :-(
I can understand what's wrong with my table/query going on, so could some one
explain me why UPDATE statemen do that strange thing...?
My table is:
CREATE TABLE `some` (
`id` bigint(20) NOT NULL auto_increme
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
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