Quick MSQL query question

[usdachoice]

In my cq_goods I have 13xx lines and I need to change owner id to 1207 for shopping mall. Is there a query that can be made to just alter the owner id and not effect anything else?

[Spy520]

try this
update cq_goods set ownerid=1207;

[usdachoice]

Originally Posted by Spy520

try this
update cq_goods set ownerid=1207;

Ah. It worked. I had forgotten then = . So when I tried it failed. Thanks :P

[funhacker]

update cq_goods set ownerid=1207;

that query WILL set ALL items in the cq_goods to 1207 this is a very bad idea as all your grocers and other shops will now not be able to sell their items

[usdachoice]

Originally Posted by funhacker

update cq_goods set ownerid=1207;

that query WILL set ALL items in the cq_goods to 1207 this is a very bad idea as all your grocers and other shops will now not be able to sell their items

Just for testing :P