mysql help

[joeydkeg]

For the tax class id, I have them all set to 0, and I need to change it to 1. Instead of going through each item 1 by 1, can I just enter a line of code through phpmyadmin to change the tax class id to 1 for all the products?

[Guest]

BACKUP YOUR DATABASE FIRST!!!

 

Using phpmyadmin, select your database, click the SQL tab then enter the following line:

UPDATE `products` SET `products_tax_class_id` =1;