sql query

bimbum* · 03/02/2019, 22:09

i want a query to update some users password
for example if i want from jid 1 to 100 to update them to e10adc3949ba59abbe56e057f20f883e

sarkoplata · 03/04/2019, 04:26

Code:

UPDATE TB_User SET password='e10adc3949ba59abbe56e057f20f883e' WHERE JID >= 1 AND JID <= 100

Ryotic · 03/05/2019, 14:56

Quote:
Originally Posted by sarkoplata
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

sarkoplata · 03/05/2019, 20:42

Quote:

Originally Posted by legendworld

No he want between not and so where jid between 1 and 100

Sent from my Redmi Note 5 using Tapatalk

same thing???

#HB · 03/06/2019, 10:07

Quote:

Originally Posted by legendworld

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!

concucu · 03/06/2019, 13:39

truncate table SRO_VT_ACCOUNT..TB_User