could somebody help me with the following query, I am pretty new
SELECT * FROM information_schema.columns Where TABLE_SCHEMA='test';
INTO OUTFILE 'file.csv';
FIELDS TERMINATED BY ',';
Thank you.
Asked
Active
Viewed 201 times
0
Raja G
- 5,973
- 14
- 49
- 82
-
What error you getting. Post that – Vignesh Kumar A Jan 21 '14 at 09:49
-
there is just red outlines and those are indicating that wrong syntax – Raja G Jan 21 '14 at 09:51
-
Please remove semi colon in first two lines – Vignesh Kumar A Jan 21 '14 at 09:54
-
Mark answer/Upvote for your questions if it's helped. May it will be useful for future reference – Vignesh Kumar A Jan 21 '14 at 09:56
-
@VigneshKumar Thank you my friend. you have helped me with two issues. the below answer helped me but I am unable to locate the csv file which contains the output. – Raja G Jan 21 '14 at 09:57
-
@VigneshKumar it is saying still time is there to wait. I can do after that.\ – Raja G Jan 21 '14 at 09:57
-
Not only this man. I think your previous question too http://stackoverflow.com/questions/21253704/how-to-save-mysql-query-output-to-excel-or-txt-file/21253740?noredirect=1#comment32019881_21253740 – Vignesh Kumar A Jan 21 '14 at 09:59
1 Answers
1
SELECT * FROM information_schema.columns Where TABLE_SCHEMA='test'
INTO OUTFILE 'file.csv'
FIELDS TERMINATED BY ',';
Why have you mentioned ; this in all the rows??
MySQL may be writing the file into its own data directory, like
/var/lib/mysql/<databasename> for example. To specify the path, use a full path.
However, it must be a directory that is writable by the user account the MySQL server daemon is running under. For that reason, I'll often use /tmp:
Specify the path you want to write to as in:
INTO OUTFILE '/tmp/mydata.csv'
Amarnath Balasubramanian
- 9,300
- 8
- 34
- 62
-
-
-
-
1
-
@rajagenupula i have updated my answer check with that – Amarnath Balasubramanian Jan 21 '14 at 09:59
-
-
1