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?
Quick MSQL query question
11/25/2008 20:25
usdachoice#1
11/25/2008 20:55
Spy520#2
try this
update cq_goods set ownerid=1207;
update cq_goods set ownerid=1207;
11/25/2008 21:03
usdachoice#3
Ah. It worked. I had forgotten then = . So when I tried it failed. Thanks :PQuote:
try this
update cq_goods set ownerid=1207;
11/26/2008 07:53
funhacker#4
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
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
11/26/2008 20:58
usdachoice#5
Just for testing :PQuote:
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