2,187
edits
Difference between revisions of "Category:MySQL"
Jump to navigation
Jump to search
Updated - MySQL page now subs off category
m (Added Applications category) |
(Updated - MySQL page now subs off category) |
||
| Line 1: | Line 1: | ||
MySQL | 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]] | [[Category: Applications]] | ||