mestre fyoda Posted October 9, 2004 Report Share Posted October 9, 2004 ei gente alguém poderia me ajudar , como faço um update com duas variaveis .exemplo :update -> status=on e online=1 Quote Link to comment Share on other sites More sharing options...
0 guilhermefm Posted October 9, 2004 Report Share Posted October 9, 2004 explicar melhor o q você quer fazer, abraço Quote Link to comment Share on other sites More sharing options...
0 mestre fyoda Posted October 9, 2004 Author Report Share Posted October 9, 2004 dentro do update quero fazer em 2 campos do banco de dados , status -> tem que ser igual a online , e online -> igual a 1 Quote Link to comment Share on other sites More sharing options...
0 f3rn4ndo_sk8_ Posted October 30, 2004 Report Share Posted October 30, 2004 ? Quote Link to comment Share on other sites More sharing options...
0 Error404 Posted October 30, 2004 Report Share Posted October 30, 2004 UPDATE tabela SET campo1='valor',campo2='valor2',campo3='valor3',...,campoN='valorN' Quote Link to comment Share on other sites More sharing options...
0 Gladisson Posted October 30, 2004 Report Share Posted October 30, 2004 É... Caso você tiver um campo especifico, coloque a referência: WHERE.UPDATE tabela SET campo1='valor',campo2='valor2' WHERE id='ValorNumero'Depois do ultimo campo a alterar não tem mais virgula. Quote Link to comment Share on other sites More sharing options...
Question
mestre fyoda
ei gente alguém poderia me ajudar , como faço um update com duas variaveis .
exemplo :
update -> status=on e online=1
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.