some usefull mysql commands---------------------------------------
1)help( \?) synonym for help.
2) clear (\c) clear command.
3)connect(\r) reconnect to the server. Optional arguments are db and host.
4)ego (\g) send command to mysql server ,display result vertically.
5)exit (\q) same as quit Exit mysql;
6)go (\g) Send command to mysql server.
7)help (\h) Display this help.
8)notee (\t) Don't write into outfile.
9)print (\p) Print current command.
10)prompt (\R) Change your mysql promptfor example :
mysql>prompt miseeql;
Result miseeql>
11)Status get status from the server.
12)use (\u) use another database.Takes database name as argument.
13)Warnings (\W) show warnings after statement.
14)nowarning (\w) Don't show warnings after every statements.
Monday, 24 November 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment