MYSQL Add vip days from a table to another one

[MxSoft]

Hi i merged my servers databases and one of my servers have the vip days in "premiumdays" and i need to add the vip days to table "vipdays".

 

[Nostradamus]

Just run that query:

UPDATE accounts SET vipdays = acc.premiumdays FROM accounts, accounts acc WHERE accounts.vipdays = acc.premiumdays;

 

[MxSoft]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM accounts, accounts WHERE accounts.vipdays = acc.premiumdays' at line 1

 

[Cykotitan]

UPDATE accounts SET vipdays = vipdays + premiumdays

and they're called columns, not tables

 

[MxSoft]

Ty so much cyko, :O yes columns

 

[Kayan]

it's fields no columns

 

[Cykotitan]

field is a column value of a single row, columns are single fields of all rows.

he wanted the query to execute for all rows and columns premiumdays & vipdays, how is that a field?