UPDATE `catalog_items` SET `cost_credits` = '0';
UPDATE `catalog_items` SET `cost_pixels` = 'PRICE';
Yes, now depending on your catalog_items structure it would go something like this:
That will make them all 0c (if that is that right structure)Code:UPDATE `catalog_items` SET `cost_credits` = '0';
This will make the items cost what you set.Code:UPDATE `catalog_items` SET `cost_pixels` = 'PRICE';
Or if you mean to swap them the best thing would just be rename the columns, also back up your database before you do this.