[StR_MaRy]

hey guys i want to open all my houses from DB is a command like

WHERE > lock '0' SET '1' in the House > SQL

[X337]

Код:

UPDATE House SET `lock` = 1 WHERE `lock` = 0

http://dev.mysql.com/doc/refman/5.7/en/update.html