Language sql help navicat
#1

Currently I want to use sql language in navicat set for membership account on level 3 gets 200 credits How to use code like? My plevel and pcredits
Reply
#2

PHP код:
 UPDATE yourtable SET pcredits='200' WHERE plevel ='3'
Reply
#3

Quote:
Originally Posted by TheToretto
Посмотреть сообщение
PHP код:
 UPDATE yourtable SET pcredits='200' WHERE plevel ='3'
I have done successfully but I want to add more as I did not do
UPDATE `accounts` SET Credits +='200' WHERE Level +='3';
Reply
#4

Rename your table to gtarp without the " - "
Reply
#5

Quote:
Originally Posted by TheToretto
Посмотреть сообщение
Rename your table to gtarp without the " - "
I want to implement add value but not?
UPDATE `accounts` SET Credits +='200' WHERE Level +='3';
Reply
#6

Done
Close topic
thanks
Reply
#7

What I understood is to set players with only the level 3, 200 Credits.

If you want to increment the values of ALL players with no condition, you can do that:

pawn Код:
UPDATE accounts SET pcredits= pcredits + 1, plevel = plevel + 1;
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)