escape mysql prompt without quitting?

[s***@gmail.com]

is it possible to escape from the mysql command prompt to the shell
without quitting altogether?

[Brian Wakem]

Post by s***@gmail.com
is it possible to escape from the mysql command prompt to the shell
without quitting altogether?

I don't think so, but you can run shell commands from the mysql prompt using
\!

For example:

mysql> \! uptime
22:28:15 up 160 days, 15:38, 5 users, load average: 0.47, 0.51, 0.50
mysql> \! perl -e 'print "Hello, World!\n"'
Hello, World!

[s***@gmail.com]

Post by Brian Wakem

Post by s***@gmail.com
is it possible to escape from the mysql command prompt to the shell
without quitting altogether?

I don't think so, but you can run shell commands from the mysql prompt using
\!
mysql> \! uptime
22:28:15 up 160 days, 15:38, 5 users, load average: 0.47, 0.51, 0.50
mysql> \! perl -e 'print "Hello, World!\n"'
Hello, World!
--
Brian Wakem
Email:http://homepage.ntlworld.com/b.wakem/myemail.png

thank you...furthermore, try this...
mysql> \! bash

[Peter H. Coffin]

Post by s***@gmail.com
is it possible to escape from the mysql command prompt to the shell
without quitting altogether?

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \h

For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Network Support, training, or other products, visit:
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear command.
connect (\r) Reconnect to the server. Optional arguments are db and
host.
delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line
as new delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute a SQL script file. Takes a file name as an
argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given
outfile.
use (\u) Use another database. Takes database name as argument.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

For server side help, type 'help contents'

----------------------------------------------------------------

That'd be a "no" on the "escaping to a shell", but a "yes" on "able to
pass commands one at a time to the shell".

Are there any other questions that could be answered with three
keystrokes been niggling at you?