Insert Statement with result record values

Asked Jun 18 '14 at 13:14

Active Jun 18 '14 at 13:17

Viewed 53 times

I have a table with 50 columns, and the table has more than one lakh records. My requirement is to get few desired records from the table and insert into another machine's database table.

Is there a way to extract the desired result records along with Insert statement? I tried doing with exporting the data, but it fetches all the records.

Any suggestions please?

asked Jun 18 '14 at 13:14

Harry

1

If it is mysql: MySQL dump by query http://stackoverflow.com/questions/935556/mysql-dump-by-query – Adrian Toma Jun 18 '14 at 13:16
You can also use[select into file](http://dev.mysql.com/doc/refman/5.0/en/select-into.html) – Jens Jun 18 '14 at 13:18
Thank you for the responses, will try both the options – Harry Jun 19 '14 at 06:23

Insert Statement with result record values

0 Answers0