Professional Web Applications Themes

escape mysql prompt without quitting? - MySQL

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

  1. #1

    Default escape mysql prompt without quitting?

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

    stephen.durkin@gmail.com Guest

  2. #2

    Default escape mysql prompt without quitting?

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

    stephen.durkin@gmail.com Guest

  3. #3

    Default escape mysql prompt without quitting?

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

    stephen.durkin@gmail.com Guest

  4. #4

    Default escape mysql prompt without quitting?

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

    stephen.durkin@gmail.com Guest

  5. #5

    Default Re: escape mysql prompt without quitting?

    com wrote:
     


    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!



    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

  6. #6

    Default Re: escape mysql prompt without quitting?

    On 5 Mar 2007 13:58:19 -0800, com wrote: 

    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?

    --
    Technical points aside, you could probably beat someone to death with
    a Newton if you had to. Try that with a Palm Pilot! --Dan Duncan in
    comp.sys.newton.misc
    Peter Guest

  7. #7

    Default Re: escape mysql prompt without quitting?

    On Mar 5, 2:30 pm, Brian Wakem <com> wrote: 
    >
    > 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!
    >
    > --
    > Brian Wakem
    > Email:http://homepage.ntlworld.com/b.wakem/myemail.png[/ref]

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

    stephen.durkin@gmail.com Guest

Similar Threads

  1. Getting the "mysql>" prompt
    By techBoy in forum MySQL
    Replies: 1
    Last Post: April 2nd, 08:48 PM
  2. PS CS keeps quitting
    By Alan_Leitstein@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 4
    Last Post: April 19th, 05:49 PM
  3. Escape characters going into MySQL
    By Geoffrey in forum FileMaker
    Replies: 4
    Last Post: November 7th, 09:07 PM
  4. G4 - apps keeps quitting!
    By K9660R in forum Mac Applications & Software
    Replies: 3
    Last Post: August 11th, 01:45 AM
  5. note 33699 added to function.mysql-escape-string
    By mathieum@sports.fr in forum PHP Notes
    Replies: 0
    Last Post: July 4th, 11:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139