distal-attribute
distal-attribute
distal-attribute
distal-attribute

copy paste record

spammich posted 7 years ago in General
is it possible to copy and paste a record in a table?
siMKin posted 7 years ago
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.