copy paste record

User, date Message
Written by spammich
6 years ago
Category: General
2 posts since Fri, 07 Sep 07 		is it possible to copy and paste a record in a table?
Written by siMKin
6 years ago
104 posts since Sun, 01 Apr 07 		You mean copy a row from one table to the other?

As far as i know it's not possible with a CTRL+C - CTRL+V kinda thing.

You could however do this:


INSERT INTO table2 SELECT * FROM table1 WHERE pk=3
# or
INSERT INTO table2 (field1, field2) SELECT field1, field2 FROM table1 WHERE pk IN (6, 19)



just two examples .. i hope you understand what i mean
 

Please login to leave a reply, or register at first.