SELECT INTO OUTFILE help

jinxy_tj · #1 (**permalink**) 02-04-12, 20:16

Hi,

I am trying to output one field of a mysql database to a file but with a condition of another fields data.

i.e...

field_a	field_b	field_c
1	a	Hello
1	b	World
2	c	Please
2	d	Help

in the above table I want to output field_c which I know I do with the following:

Code:

SELECT field_c INTO OUTFILE '/tmp/file.txt' FROM table;

BUT... could my output file contain just field_c data but only if field_a = 1

so in this instance my output would be Hello World

Thanks in advance for any help

r937 · #2 (**permalink**) 02-04-12, 20:56

Code:

SELECT GROUP_CONCAT(field_c SEPARATOR ' ') AS output
  INTO OUTFILE '/tmp/file.txt' 
  FROM table
 WHERE field_a = 1

jinxy_tj · #3 (**permalink**) 02-04-12, 21:52

Perfect, Thanks very much.

Output is a little different but easily fixed with the below code just for reference if anyone happens to find this useful:

Code:

tr ' ' '\n' < file.txt > output.file.txt

Thanks r937

r937 · #4 (**permalink**) 02-04-12, 21:59

hold on a sec... you ~didn't~ want Hello World concatenated??

because that's sure what it looked like you wanted

try this instead...

Code:

SELECT field_c AS output
  INTO OUTFILE '/tmp/file.txt' 
  FROM table
 WHERE field_a = 1

jinxy_tj · #5 (**permalink**) 02-04-12, 22:13

Thanks r937,

Yes I can see that my post was mis-leading, thanks again for your help!

Internet Services

Web Development

Digital Marketing

Consumer Tech