"Mike(mickalo)Blezien" wrote: > > On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia <[EMAIL PROTECTED]> wrote: > > >>You can export using > >>SELECT fieldlist INTO OUTFILE "filename" FROM table; > >> > >>This will create a file with tab separated fields. It is Excel default separator. > >>Within Excel, you can open the file, by giving filetype text, and a wizard will > >>guide you through the translation. > >> > >>You can create a CSV file by adding , at the end of the SQL statement, > >>FIELDS TERMINATED BY ',' ENCLOSED BY '"' > > thanks, that this should work perfectly. one other question regarding the select > .. into outfile.. > > this is the query being used: > > SELECT * INTO OUTFILE "/home/tracerta/tmp/producd_id.txt" > FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' > FROM product_id; > > Now if I log into mysql under the client's username password, which has full > privilegs on the database being used here: 'tracers' it will not allow this > query to be executed, I keep getting the error, "access denied for > tracerta@localhost using password (yes)." > > But if I log into mysql under 'root', then I can execute the query with no > problems. The OUTFILE is in the client's account on the server, the 'tmp' folder > is chmoded 0777 and owned by the client 'tracerta'
The outfile created by the query is owned by ident which runs the MySQL server. > > Is there a special privilege setting for selecting into outfile ?? I'd like to know if a user can output a file owned by the user too. > > thanks, > > database mysql > > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Tel: 1(225)686-2002 > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
