Member Avatar for Tess James

I need to copy only some selected rows from a table and insert these rows into another table (having the same structure) in another database. Is it possible?

  • 3 Contributors
  • 3 Replies
  • 6K Views
  • 6 Years Discussion Span
  • Latest Post Latest Post by guruparthi
Member Avatar for marrrrrrc

Do something like:

INSERT INTO table1 (col1, col2, col3) SELECT col1, col2, col3 FROM table2 WHERE col4='some value'
Member Avatar for Tess James

Thanks a lot friend..

Member Avatar for guruparthi

Insert into table2 (column_name1, column_name2) select column_name1, column_name2 from table1 where column_name1='value'

Edited by pritaeas because: Removed self-promotion link.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.