SA-MP Forums Archive
[Ajuda] mudar valor de coluna para todos os players MYSQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] mudar valor de coluna para todos os players MYSQL (/showthread.php?tid=602071)



mudar valor de coluna para todos os players MYSQL - warriorfrog - 01.03.2016

na tabela accounts

mudar as colunas de todos os players

playerlint
playerlvw

pra 0


Re: mudar valor de coluna para todos os players MYSQL - Dayvison_ - 01.03.2016

Sу nгo adicionar a causula WHERE na query.


Re: mudar valor de coluna para todos os players MYSQL - unamed - 01.03.2016

UPDATE `accounts` SET `playerint`=0,`playervw`=0 WHERE 1


Re: mudar valor de coluna para todos os players MYSQL - WooPz - 01.03.2016

Quote:
Originally Posted by unamed
View Post
UPDATE `accounts` SET `playerint`=0,`playervw`=0 WHERE 1
nгo precisa do where.


Re: mudar valor de coluna para todos os players MYSQL - warriorfrog - 02.03.2016

Quote:
Originally Posted by Day_
View Post
Sу nгo adicionar a causula WHERE na query.
Obrigado!