This doesn't work for me... However, I could use CTRL+Z (suspend) and then
fg to get back...
[daevid=pts/0]1:12pm@silver:{/home/daevid}> mycrm
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12476 to server version: 3.23.56-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> \! ls
ERROR:
Unknown command '\!'.
-> ;
ERROR 1064: You have an error in your SQL syntax near '\! ls' at line 1
mysql> \! ls *.sql
ERROR:
Unknown command '\!'.
-> ;
ERROR 1064: You have an error in your SQL syntax near '\! ls *.sql' at line
1
mysql>
Suspended
[daevid=pts/0]1:13pm@silver:{/home/daevid}> fg
mysql -hlocalhost -uroot crm
mysql> ls
-> ;
ERROR 1064: You have an error in your SQL syntax near 'ls' at line 1
mysql>
> -----Original Message-----
> From: Curtis Maurand [mailto:curtis@stripped]
> Sent: Friday, May 02, 2003 6:47 AM
> To: Dan Nelson
> Cc: Myhre, Julie; mysql@stripped
> Subject: Re: Getting to the shell from mysql> prompt
>
>
>
> And I searched for that in the docs yesterday, too. I
> couldn't find it
> anywhere. I searched on the terms "shell," "external," and
> "ext." then
> again, I wasn't searching using the website search function.
> I was looking
> in the table of contents.
>
> hrmmm.
>
> Curtis
>
> On Thu, 1 May 2003, Dan Nelson wrote:
>
> > In the last episode (May 01), Myhre, Julie said:
> > > Is there a way to spawn off to the shell from the mysql prompt,
> > > either for a quick shell command (like an ls of your current
> > > directory), or to stay there and run a couple commands,
> then get back
> > > to the same mysql session?
> > >
> > > For example, on a UNIX box, from an Oracle SQL*Plus
> prompt I can do:
> > > sqlplus>!ls *.sql
> > >
> > > Or just type the ! and get to my shell. When I type 'exit' I am
> > > returned to that sqlplus prompt.
> >
> > Try:
> >
> > mysql> \! ls *.sql
> >
> > For a plain shell, run "\! sh", or whatever your favorite shell is.
> >
> >
>
> --
> --
> Curtis Maurand
> mailto:curtis@stripped
> http://www.maurand.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?> unsub=daevid@stripped
>
