Editing MySQL basics (section)

== Basic Commands ==

Virtually all commands are terminated with a semicolon.
The prompt '->' means MySQL is waiting for more instructions or the semicolon is missing.<br>

Cancel current command <code>\c</code> and press Enter.<br>

MySQL will ignore anything in a command that ends with <code>\c</code> and go back to beginning.

Type <code>exit</code> or <code>quit</code> and press Enter anytime you want to exit. These commands do not require a semicolon.

<code>show table status;</code>

<code>show databases;</code>

<code>drop database <db_name>;</code>

<code>create database <db_name>;</code>

<code>use <db_name>;</code>

<code>show tables;</code>

<code>show <table_name>;</code>

<code>describe <table_name>;</code>

<code>drop table <table_name>;</code>

<code>DISTINCT</code> informs query to eliminate duplicate result rows

<code>\</code> tells MySQL to treat the next character as a character string instead of any special meaning that it may have.

mysql>SHOW DATABASES;

mysql>DROP DATABASE [databasename];

mysql>CREATE DATABASE [databasename];

mysql>\h Among other things, \h produces this output:

<pre>
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.
prompt  (\R)    Change your mysql prompt.
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.
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.
</pre>