GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - GFY MySQL gurus! (https://gfy.com/showthread.php?t=538375)

Rhesus

11-09-2005 12:44 PM

GFY MySQL gurus!

What query should I run if I want to do this:

Export the contents of ColumnA of table Database1.Table1 into locally stored txt file /usr/home/blah/text.txt, one new entry per line?

Many thanks in advance!

psili

11-09-2005 12:46 PM

Look into "select into outfile"

Code:

SELECT * INTO OUTFILE '/tmp/dump.txt' FROM img

http://elib.cs.berkeley.edu/admin/mysql/syntax.html

Rhesus

11-09-2005 01:53 PM

Thanks :-)

All times are GMT -7. The time now is 10:28 AM.