I have two tables A and B. I want to update rows in Table A depending on the back up data stored in Table B.
Table A = most current table of data Table B = 5 day old back up of table A
Structure of both Table A and B:
item_id(unique int), item_type(int), enchant(int)
I have a list(array) of 'item_type':
item_type = 1, 5, 6, 7, 10
For each row in Table B with item_type == 1, 5, 6, 7, or 10 the script should add 5 + 'enchant' and store this updated data in Table A WHERE TableA.item_id == TableB.item_id.
Please help! =)
If you didn' understand that please ask and I'll try to explain it better. (BTW, this script will be helping an online gaming community of over 2000 users)