in reply to Obtaining field names only
Or else use DBD::CSV and loop through a mysql select doing CSV inserts.my $select = "SELECT * FROM mysqlTable"; # or whatever my $ad_dbh = DBI->connect(...AnyData...); my $mysql_dbh = DBI->connect(...mysql... ); $ad_dbh->import("tmp",'DBI',$mysql_dbh,{sql=>$select}); $ad_dbh->export("tmp",'CSV','myfile.csv); # all done!
Or else use MySQL's dump facility. I forget what it's called, but I think you can export directly to CSV from MySQL.
|
|---|