A
A
Anton Misyagin2015-12-29 19:12:30
Ruby on Rails
Anton Misyagin, 2015-12-29 19:12:30

How to correctly copy a row from table to table?

There are 2 tables with the same structure, is there a nice way to copy a row from one such table to another without listing numerous fields including id?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
res2001, 2015-12-29
@res2001

insert into table1
select * from table2 where <selection condition here>

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question