2,187
edits
m (Initial creation) |
(Updated - MySQL page now subs off category) |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
MySQL Category | See the official [http://dev.mysql.com/doc/ MySQL documentation] for further info. | ||
== Basic Commands == | |||
{|class="vwikitable" | |||
|- | |||
! Command !! Description | |||
|- | |||
| <code> SHOW DATABASES; </code> || Show databases on server | |||
|- | |||
| <code> USE <db_name>; </code> || Use / go into a database | |||
|- | |||
| <code> SHOW TABLES; </code> || Show tables in current database | |||
|- | |||
| <code> DESCRIBE <tbl_name>; </code> || Show the format of the table | |||
|- | |||
| <code> CREATE DATABASE <db_name>; </code> || Create a database | |||
|- | |||
| <code> DROP DATABASE <db_name>; </code> || Drop (delete) a database | |||
|} | |||
[[Category: Applications]] |