Category:MySQL: Difference between revisions

Latest revision as of 22:10, 16 March 2014

See the official MySQL documentation for further info.

Command	Description
`SHOW DATABASES;`	Show databases on server
`USE <db_name>;`	Use / go into a database
`SHOW TABLES;`	Show tables in current database
`DESCRIBE <tbl_name>;`	Show the format of the table
`CREATE DATABASE <db_name>;`	Create a database
`DROP DATABASE <db_name>;`	Drop (delete) a database

This category has only the following subcategory.

The following 13 pages are in this category, out of 13 total.

@@ Line 1: / Line 1: @@
-MySQL Category page!
+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]]