Control-A and control-E are good ones.. ^A will go to the
begginning of a line and ^E goes to the end. Also, ESC-b and ESC-f will
go back/forward word by word.
You can also type \e to load your current statement into an editor,
which lets you harness the navigation/text-control power of your
favorite editor.
But of course I think these are all dependant on your OS...
This is documentation for GNU readline, which is what the mysql client
uses to be interactive (^A and ^E for example are part of readline, not
the mysql client itself):
http://cnswww.cns.cwru.edu/~chet/readline/rluserman.html
This is from the manual:
mysql> help
MySQL commands:
help (\h) Display this text.
? (\h) Synonym for `help'.
clear (\c) Clear command.
connect (\r) Reconnect to the server. Optional arguments are db and
host.
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.
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.
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.
tee (\T) Set outfile [to_outfile]. Append everything into given
outfile.
use (\u) Use another database. Takes database name as argument.
Ernie Hershey
[EMAIL PROTECTED]
-----Original Message-----
From: Barbara Ferrell [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 21, 2001 9:25 AM
To: [EMAIL PROTECTED]
Subject: Where can i find a list of keystroke commands for MYSQL?
> i am two days new in learning MYSQL and am designing a table. i
> can't
get back to the beginning of the table when i notice a typo and also
even
back to the beginning of my line without overwriting everything. i
have
spent forever looking everywhere .. i can't even backspace past the
>.
>
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
