Questions tagged [select-into-outfile]

I'm trying to load data of a table into a csv file. However rows in file are broken in between. The data of table seems fine and there is no \n anywhere. Then why am I getting breaks in rows? Query I'm executing is select * from `abc_csv` into…

I am trying to optimize the export process of a query. I have the following tables (I omit some irrelevant fields): CREATE TABLE _termsofuse ( ID int(11) NOT NULL AUTO_INCREMENT, TTC_ART_ID int(11) DEFAULT NULL, TTC_TYP_ID int(11) DEFAULT…

i'd like to make an export into CSV format, but the mutualised host i use has deactivate the FILE functions in mysql. I did a simple SELECT and then a fopen and fwrite with PHP. The problem is that in fields there is carriage returns or double…

Why would the following query appear to run but I never can find the file outfile? select * INTO OUTFILE 'outfile.csv' FIELDS TERMINATED by ',' LINES TERMINATED BY '\n' from nGrams I have MySQL 5.5 and I am running…