Duplicating a row in MySQL

[Anon]

Hello

Is it possible to duplicate a row in MySQL?
If so how do i do this?

Thanks

[crimaniak]

Just insert a row with duplicated values.

[[deleted]]

🙂 most people come here to ask how they can get rid of duplicates.

It's more difficult than it sounds, mysql does not support inserting into the same row you select from, so this will not work:

INSERT INTO table SELECT * FROM table WHERE id=foo;

You'll have to do a select, store the data in php, build an insert query and execute it.

Also, remember that if you have 100% duplicate rows, there is no way in hell to get SQL to ever find one of them specifically, the will always match all queries exactly the same way (which is why you never want to have 100% duplicates in the first place)

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[ziggs]

"Also, remember that if you have 100% duplicate rows, there is no way in hell to get SQL to ever find one of them specifically, the will always match all queries exactly the same way (which is why you never want to have 100% duplicates in the first place)" -Vincent

What if you have a table that has a slick_id INT NOT NULL AUTO_INCREMENT then every time you make a new entry it adds a number. So you could have it call different id's. Therefore having MySQL get differnet rows by id number. Though all information would be the same, but in theory it will have a different ID number.
Ziggs

[nigel_belanger]

That would work - I'm so curious as to WHY you would want all of those duplicate entries?