adding a mysql column to a tab delimited file
Posted on 2011-04-22
I have a mysql database with a table called Feature and an autoinc primary key.
I also have a tab delimited file with one row per feature. This file does not contain the Feature autoinc primary key. The rows in the tab delimited file are in the same order as the rows were inserted into the mysql database.
Basically i want to add the feature_id pk as a column to this tab delimited file. I could write a script but I was wondering if there was an easier way to export a mysql table column(s) to an existing tab delimted file
I've tried searching for this but all the results that come back just tell me how to export data as a new tab file but i want to add to an existing file