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