copy paste record

User, date Message
Written by spammich
7 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
7 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.