Copying Rows

[Void]

Is there a way to copy rows in MySQL? I need to copy the same data 15 times and would rather not type it in. The only thing I need changed is the ID which is set to auto-increment.

[WingedPanther]

I would use the Insert command from SQL 15 times, specifying everything except the ID.

[Jordan]

Originally Posted by WingedPanther

I would use the Insert command from SQL 15 times, specifying everything except the ID.

After looking through the commands I couldn't find anything so I would have to suggest what WingedPanther said as well.

[voldron]

Couldn't this be possibly done using a sub query?

INSERT INTO employees3 (id,Lastname,Firstname,Title) (SELECT id,Lastname,Firstname,Title FROM employees WHERE Title='manager');


Something like the above. I know that Subquerys have just recently be supported fully in MySQL
;-)

[Jordan]

It might be possible for this to work. It would be interesting to know if it did work.

[voldron]

yep it worked. I did a little test and it worked

[Patrick]

Yeah I also used this command and it's working very efficiently. That is really a great work. I would like to appreciate all the effort drawn by members of this forum.

Cheers.