Sql query / Move Videos

**MissKalunji** · 16-09-2009, 21:52

I want to mass move everyvideo from categoryid 11 to category 7

What's the proper sql query for that?

Thanks

**MissKalunji** · 18-09-2009, 06:24

bump?!?!? i'm still wondering 29 pages to do manually is long

**s7v7n** · 18-09-2009, 07:59

Please make a backup before running this query of vbtube_tubes table.
I can give only support if you backup.

**MissKalunji** · 18-09-2009, 22:26

uhm isn't it missing a portion? as in update categoryid 11 to 7?

**s7v7n** · 19-09-2009, 10:44

OMG Sorry i didn't read your post correctly.

PHP Code:


UPDATE prefix_vbtube_tubes SET categoryid = 7 WHERE categoryid = 11

**MissKalunji** · 20-09-2009, 04:14

great

that did the trick.

**MissKalunji** · 25-11-2009, 21:59

this doesn't seem to work anymore did you change the tables name?

**Pilotnetwork** · 25-11-2009, 22:24

Is it also possible to copy everyvideo from categoryid 1 to category 2.

How do I do this?

**s7v7n** · 26-11-2009, 08:54

http://www.vbtube.com/howto-faq/3398...html#post12676

This copying all videos from catid 11 to catid 7

Thread: Sql query / Move Videos