Houses MySql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Houses MySql (/showthread.php?tid=565836)

---

Houses MySql - Trevor Gin - 01.03.2015

how i can set all houses to level 9999 from mysql?

---

Re: Houses MySql - Trevor Gin - 01.03.2015

ERROR
http://gyazo.com/9a678b023c966e42876f03089b3c5b46

---

Re: Houses MySql - MikE1990 - 01.03.2015

You should UPDATE not SELECT just copy Ralfie query and paste it there.

---

Re: Houses MySql - Trevor Gin - 01.03.2015

Yeah, Works thank you but how to edit biz price too, this not works
UPDATE `businessale` SET `price`='999999999' WHERE `id`> 0

---

Re: Houses MySql - MikE1990 - 01.03.2015

Can you show your bizz structure ?

---

Re: Houses MySql - Trevor Gin - 01.03.2015

http://gyazo.com/02ab2423b5b8c13b4bc3ec3120a57a24

---

Re: Houses MySql - MikE1990 - 01.03.2015

UPDATE `businesssales` SET `Price`='9999' WHERE `bID`> 0

---

Re: Houses MySql - Trevor Gin - 01.03.2015

Thank you very much, i'll rep you.

---