SQL - Output into file

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 60294
interpreted = N
texte = SELECT votes,percent INTO OUTFILE '/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM candidates_co; This code is right out of the MySql manual. I get a 'can't create/write' error. The docs say the FilePriv must be set to Y, which according to the MySQL tables is. Any ideas? Larry Hewitt360.807.1100 OFFICE HCO, LLC 360.807.1103 FAX 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL - Output into file ( "Jason Aus" 2004)
  2. Re: SQL - Output into file ( "Jason Aus" 2004)
  3. Re: SQL - Output into file ( Larry Hewitt 2004)
  4. Re: SQL - Output into file ( Brian Fries 2004)
  5. SQL - Output into file ( Larry Hewitt 2004)
SELECT votes,percent INTO OUTFILE '/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM candidates_co; This code is right out of the MySql manual. I get a 'can't create/write' error. The docs say the FilePriv must be set to Y, which according to the MySQL tables is. Any ideas? Larry Hewitt360.807.1100 OFFICE HCO, LLC 360.807.1103 FAX 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Larry Hewitt

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

changing prices in cart (1997) emailer (1998) debit cards and checksum (1998) PIXO Support (1997) Return records from another (1997) Server Freeze (1998) Separate SSL Server (1997) PCS Frames (1997) Re:Copyright ? (1997) Snake Bites (1997) Where is f2? (1997) Area codes? (2001) [format 40s]text[/format] doesn't work (1997) RSH [shell] calls. (2004) [WebDNA] Facebook Application - Custom Tab for Fan / Non-Fan (2011) [SHOWIF AND/OR] (1997) Math (1997) unable to launch acgi in WebCat (1997) problems with 2 tags (1997) Template Cache problem (2000)