[AndMetal]

I don't think this will work because we use MyISAM on the items table, but check this out:
How to copy row(s) into same Table

Re: How to copy row(s) into same Table
Posted by: Marc Antonijoan ()
Date: May 06, 2008 07:35AM

I did it using this SLQ query:

SELECT row_1 FROM table FOR UPDATE;
UPDATE table SET row_2 = row_1;

It worked just fine.

Check this web page for more info:

http://dev.mysql.com/doc/refman/5.0/...ing-reads.html

Marc