MySQL query

[Guest]

Somwhat ambitiously I uploaded my entire product database using phpMyAdmin, some 3,500 products.

 

The upload went fine, but ......... I put all the products into a single category.

 

Now when I try to view the products in Admin, the server times out. What I need to do is to spread the products over a number of categories.

 

I have no MySQL skills.

 

Can anyone tell me what command I use to change records 500 to 1,000 from Category ID 113 to Category ID 114 in the Product to Category table.

 

And then records 1,000 to 1,500 from cat ID 113 to Cat ID 115 etc.

 

Or is there a better way to approach this?

[Guest]

OK ... I'm working my way through this ...

 

How far off am I with this ....?

 

UPDATE products_to categories

SET categories_id=categories_id+1

LIMIT row_count=500

 

 

If that works, then I still need to be ables to select the starting rows for the query ...

[user99999999]

Why not use Easy Populate and try again?

[♥yesudo]

Try this but backup your db first:

 

UPDATE `products_to_categories` SET `categories_id` = '114' WHERE `products_id` > '499' AND `products_id` < '1001' AND `categories_id` = '113';

[Guest]

Thanks, that SQL query worked a treat :-)

[♥yesudo]

phew..