Duplicating items in My SQL

[Incognito]

I was wondering if there's a way to duplicate all weapons and armor in MySQL (workbench) (I can't seem to copy columns and rows together). I know there are commands, but I'm not familiar with them. Maybe someone could type the command out for me or give me a list to get me started.

 

I'm looking for something that.. copies all columns where item type = 4 or 5 in item_db to item_db2

and another that.. renames rows 1st#-nth# to mth#-sth# (n,m,s are just arbitrary numbers; n<m<s  and  sth# - mth# = nth# - 1st#)

 

Thanks

Edited February 23, 2013 by Incognito

[Kenpachi]

INSERT INTO `item_db2`
    SELECT * FROM `item_db` WHERE `type` = 4 OR `type` = 5;

But I don't understand what you want to rename...

[Incognito]

Oh, I wanted to rename the rows in a column.

 

Say we had the column `id`:

 

id   ->   id

1    ->   1

3    ->   2

5    ->   3

2    ->   4

7    ->   5

 

I just used...

 

SET @cnt = 25000;
UPDATE `ragnarok`.`item_db2`
SET `id` = @cnt := (@cnt + 1)
WHERE `id`= 4;

 

 

and thanks!