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:quen...@infinity.co.nz Phone : +64 9 358 9720 Fax : +64 9 309 4142

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jason=info...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php