|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
11-09-2005, 12:44 PM
|
#1 |
|
Confirmed User
Join Date: Aug 2004
Posts: 2,009
|
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! |
|
|
|
11-09-2005, 12:46 PM
|
#2 |
|
Confirmed User
Join Date: Apr 2003
Location: Loveland, CO
Posts: 5,526
|
Look into "select into outfile"
Code:
SELECT * INTO OUTFILE '/tmp/dump.txt' FROM img
__________________
Your post count means nothing. |
|
|
|
|
11-09-2005, 01:53 PM
|
#3 |
|
Confirmed User
Join Date: Aug 2004
Posts: 2,009
|
Thanks :-)
|
|
|
|
