@MySQL commands

MySQL commands:

N
[Macintosh:l] root# /usr/local/mysql/bin/mysql -u root -p
Enter password:123456

Note that all text commands must be first on line and end with ';'

help (_h) Display this help.
? (_?) 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.
Connection id: 4 (Can be used with mysqladmin kill)
I _q


INDEX