Query to copy built-in cash to new field

[Regs]

I'll be soon implementing a credits/points system and will have a dedicated currency for sportsbook.

Setting it up to use the new credit field is easy enough but I would like to transfer any current sportsbook cash each user has into the new field before flipping the switch.

@Bob - can you supply me with a simple query I can use in phpmyadmin to copy over the data?

Cheers,

Regs.

 

[Bob]

is the target field empty or does it have values?

 

[Regs]

It'll be empty

 

[Bob]

If the new field is empty, then its a rather simple query (basically copying the data from one field to another)

UPDATE tableName
SET new_field = old_field

UPDATE xf_user
SET name_of_your_new_field = sportsbook_cash

 

[Regs]

Awesome, thanks @Bob !