SELECT * INTO OUTFILE ‘/tmp/result.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ FROM tablename;
esportare in un file csv i risultati di una query in mysql
Published: 4 novembre 2009Posted in: software
SELECT * INTO OUTFILE ‘/tmp/result.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ FROM tablename;