====== SQL Commands ======

{{template>:meta:template:pageinfo#tpl |desc=Document some <wrap pkg>SQL</wrap> commands.}}

===== Database =====

==== Statements ====

<WRAP not>Table 1. Statements to access database</WRAP>
<datatables>
^                                                                     ^                                                       ^
| <wrap cmd>show databases [like '<wrap cmdp>pattern</wrap>']</wrap>  | List all databases.                                   |
| <wrap cmd>use <wrap cmdp>database</wrap></wrap>                     | Select the database to interact with.                 |
| <wrap cmd>show tables [like '<wrap cmdp>pattern</wrap>']</wrap>     | Lists all tables in the currently selected database.  |
</datatables>

<callout type="info">
In the above commands, ''%'' is used as a wildcard in the <wrap cmdp>pattern</wrap>.
</callout>

==== Demo ====

<codeprism lang=sql cmdout=2-12,14-20,22-23,25-31>
show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| stats              |
| sys                |
+--------------------+
5 rows in set (0.001 sec)

show databases like '%sql%';
+------------------+
| Database (%sql%) |
+------------------+
| mysql            |
+------------------+
1 row in set (0.001 sec)

use mysql
Database changed

show tables like 'column%';
+---------------------------+
| Tables_in_mysql (column%) |
+---------------------------+
| column_stats              |
| columns_priv              |
+---------------------------+
2 rows in set (0.001 sec)
</codeprism>

===== Table =====

==== Statements ====

<WRAP not>Table 2. Statements to access table</WRAP>
<datatables>
^ Statement                                                                               ^ Description                                              ^
| <wrap cmd>delete from <wrap cmdp>table</wrap> where <wrap cmdp>condition</wrap></wrap>  | Delete the specified rows.                               |
| <wrap cmd>show columns from <wrap cmdp>table</wrap></wrap>                              | Lists information about the columns in specified table.  |
</datatables>