Learning Mysql

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 an SQL script file. Takes a filename 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.
charset (C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (W) Show warnings after every statement.
nowarning (w) Don't show warnings after every statement.
For server side help, type 'help contents'
Depending on the version of the monitor that you’re using, you may see a different list.
The characters in the parentheses indicate a shortcut for each command. You typed in the
USE
command earlier in this chapter to change to the test database. From the list,
you can see a short description of this command and also see that you can type u instead of
USE
Let’s look at another entry on this list. The monitor has command completion, just like the Linux and Mac OS X shells, and like the Windows command prompt. You can press the Tab key to complete SQL statements and table and attribute names. If not all the options you expect are shown, you can update the internal list of expansions
(“rebuild the completion hash) by typing rehash (or using the shortcut characters) and pressing the Enter key.
Using the help function of the monitor, you can also get help on how to interact with the MySQL server. To see a table of contents for the help documentation, type HELP
Contents:
mysql> HELP Contents
You asked for help about help category "Contents"
For more information, type 'help ', where is one of the following categories:
Account Management
Administration
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUP BY

Download 4.24 Mb.

Share with your friends: