mysql> help
for information about Mysql products and services ,visit:
For developer information, including the MySQL Reference Manuak,visit:
To buy MySQl Network Support ,training,or other products.visit:
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 reset of the line as new delimiter.
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 thid help.
notee </t>Don't write into outfile.
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 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.
charset </C> Switch to another charset . Might be needed for processing binlog mutil-byte
warnings </W> Show warnings after every statement.
nowarning </w> Don't show warnings after every statement.