Re: Feature Requests
Mike Wexler writes: Quentin Bennett wrote: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; mysql select col into local outfile '/tmp/data.txt' from table Would these options prove useful to others? Yes. Especially the local outfile. 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 Hi! Regarding shell commands it is doable. Regarding local outfile, there are some clients that do it already, like mysqlgui. Fixing it to work in general case is also doable, but it is not a small feature. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: Feature Requests
Quentin Bennett wrote: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; mysql select col into local outfile '/tmp/data.txt' from table Would these options prove useful to others? Yes. Especially the local outfile. 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 - 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
Re: Feature Requests
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