Sms Shop

[Slimek]

I have a question what is the command to the database to add all accounts 500 point to sms shop. UPDATE `players` SET `premium_points` = `premium_points`+500; not working . Error: 1054 - Unknown column 'premium_points' in 'field list'.

I Give Rep++

 

[VirrageS]

There isn't in table "players" column "premium_points"
Try this:

UPDATE accounts SET premium_points = premium_points + 500

 

[Slimek]

the same #1054 - Unknown column 'premium_points' in 'field list'

 

[soba]

update accounts set premium_points=premium_points+30

 

[VirrageS]

I edited try now

P.S. For it's working prefectly

 

[Slimek]

OK VirrageS Rep++