MySQL Question
#1

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 :/

Reply
#2

Comment removed

*Ye xD*
Reply
#3

Don't post If you are not sure, bro
Reply
#4

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.
Reply
#5

Ok, thank you bro
Reply
#6

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

Код:
UPDATE Houses SET OwnerName = "Nobody" WHERE OwnerName != "Nobody"
I believe a query like that should work.
Reply
#8

I really love you, bro
Thanks for everything
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)