MySQL export query as insert statements

mysql export
RailsSon picture RailsSon · Sep 24, 2010 · Viewed 56.5k times · Source

I have two mysql tables which both have a typeID in common. I am wanting to select everything from these two tables with the same typeID, query below:

SELECT ta.requiredTypeID, ta.typeID, ta.quantity 
  FROM `invtypes` as t, `typeactivitymaterials` as ta 
  WHERE volume > 0 AND t.typeID = ta.typeID;

This gives me the correct results but I am trying to export this query as insert statements. I have tried adding INTO OUTFILE "/path/" but this only exports the data as tab/comma delimited data, is it possible to export this data as insert statements?

Cheers

Eef

Answer

a'r picture a'r · Sep 24, 2010

You might be able to use mysqldump instead. Check out the parameters --tables and --where=.

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Related questions

Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code: $…

Read More
Exporting results of a Mysql query to excel?

My requirement is to store the entire results of the query SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) to an Excel file.

Read More
mysqlworkbench giving version error on exporting database

When I try to export my database through MySQL Workbench remotely from localserver, I am getting some below version error: mysqldump Version Mismatch [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. Because the …

Read More