I'll add my voice especially on the local file. many times I have wanted to be able to skip creating the file on the server, then having to scp it to my local box.
On Tuesday 11 December 2001 02:09 pm, you wrote: > Hi, > > I would like to request the addition of the following features to the > command line client: > > Shell escape > > mysql> !rm /tmp/data.txt > mysql> select col into outfile '/tmp/data.txt' from table; > > The command is run on the client. It would all SQL scripts to be run more > simply that constructing a shell script with the same function. Maybe there > would need to be an extra user permission to avoid abuse (like FILE)? > > Because the command is run on the client, this leads to the second feature > request: > > mysql> select col into local outfile '/tmp/data.txt' from table > > Before submitting to the server, the client checks, with the server, that > the user has FILE privileges, and that the user has OS level permission to > create the file. > > The results of the query are then put in to the file in the same format as > they would have been in the existing select .. into outfile command - if > that is too difficult, because the client then needs all the separator and > terminator options, then simply tab separated using the platform's standard > end of line would be fine for me! > > Would these options prove useful to others? > > Regards > > Quentin Bennett > Transport Systems Division > Infinity Solutions > web http:\\www.infinity.co.nz > mailto:[EMAIL PROTECTED] > Phone : +64 9 358 9720 > Fax : +64 9 309 4142 > > > The information contained in this email is privileged and confidential > and intended for the addressee only. If you are not the intended > recipient, you are asked to respect that confidentiality and not > disclose, copy or make use of its contents. If received in error > you are asked to destroy this email and contact the sender immediately. > Your assistance is appreciated. > > --------------------------------------------------------------------- > 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 -- Jayce^ --------------------------------------------------------------------- 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