Solved Mysql Help

[_Aion_]

Hello, i'm trying copy one value to another table.
i need copy vipdays(table players) to vipdays(table accounts)

how i made it?

 

[Zippiex]

Hello, i'm trying copy one value to another table.
i need copy vipdays(table players) to vipdays(table accounts)

how i made it?

How to copy data from one table to another new table in MySQL?

 

[_Aion_]

How to copy data from one table to another new table in MySQL?

I tried, but result in 0 rows.

here my code

UPDATE accounts SET vipdays = ( SELECT vipdays FROM players WHERE account_id = id LIMIT 1)