MySQL Question - Printable Version

MySQL Question - 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: MySQL Question (/showthread.php?tid=515641)

MySQL Question - VladimirMark - 27.05.2014

Ok, so I own a database which I want all "Owned" value to 0 from 1
Is any way to do it at once, or I need to do it one by one because I have to many houses :/

Re: MySQL Question - ajam112 - 27.05.2014

Comment removed

*Ye xD*

Re: MySQL Question - VladimirMark - 27.05.2014

Don't post If you are not sure, bro

Re: MySQL Question - Calgon - 27.05.2014

Run this SQL query:

Код:

UPDATE Houses SET Owned = 1 WHERE Owned = 0

Change "Houses" to the table name you're using if that's not correct.

Re: MySQL Question - VladimirMark - 27.05.2014

Ok, thank you bro

Re: MySQL Question - VladimirMark - 27.05.2014

Another Question, If I want to edit the "OwnerName" to "Nobody" and it has different names how can I do it?

Re: MySQL Question - Calgon - 27.05.2014

Код:

UPDATE Houses SET OwnerName = "Nobody" WHERE OwnerName != "Nobody"

I believe a query like that should work.

Re: MySQL Question - VladimirMark - 27.05.2014

I really love you, bro
Thanks for everything