sql query

03/02/2019 22:09 bimbum*#1
i want a query to update some users password
for example if i want from jid 1 to 100 to update them to e10adc3949ba59abbe56e057f20f883e
03/04/2019 04:26 sarkoplata#2
Code:
UPDATE TB_User SET password='e10adc3949ba59abbe56e057f20f883e' WHERE JID >= 1 AND JID <= 100
03/05/2019 14:56 Ryotic#3
Quote:
Originally Posted by sarkoplata View Post
Code:
UPDATE TB_User SET password='e10adc3949ba59abbe56e057f20f883e' WHERE JID >= 1 AND JID <= 100
No he want between not and so where jid between 1 and 100

Sent from my Redmi Note 5 using Tapatalk
03/05/2019 20:42 sarkoplata#4
Quote:
Originally Posted by legendworld View Post
No he want between not and so where jid between 1 and 100

Sent from my Redmi Note 5 using Tapatalk
same thing???
03/06/2019 10:07 #HB#5
Quote:
Originally Posted by legendworld View Post
No he want between not and so where jid between 1 and 100

Sent from my Redmi Note 5 using Tapatalk
LoL? Both actually equal!
03/06/2019 13:39 concucu#6
truncate table SRO_VT_ACCOUNT..TB_User