Difference between revisions of "MySQL"

Jump to navigation Jump to search
100 bytes removed ,  14:52, 18 January 2010
m
Undo revision 653 by Sstrutt (Talk) - Syntax Highlighting made table too big
m (→‎Basic Commands: Added SyntaxHighlight)
m (Undo revision 653 by Sstrutt (Talk) - Syntax Highlighting made table too big)
Line 5: Line 5:
{|cellpadding="4" cellspacing="0" border="1"
{|cellpadding="4" cellspacing="0" border="1"
|- style="background-color:#bbddff;"
|- style="background-color:#bbddff;"
! Command                                                         !! Description
! Command                                         !! Description
|-
|-
| <source lang="mysql"> SHOW DATABASES; </source>                  || Show databases on server
| <code> SHOW DATABASES; </code>                  || Show databases on server
|-
|-
| <source lang="mysql"> USE <db_name>; </source>                    || Use / go into a database
| <code> USE <db_name>; </code>                    || Use / go into a database
|-
|-
| <source lang="mysql"> SHOW TABLES; </source>                      || Show tables in current database
| <code> SHOW TABLES; </code>                      || Show tables in current database
|-
|-
| <source lang="mysql"> DESCRIBE <tbl_name>; </source>              || Show the format of the table
| <code> DESCRIBE <tbl_name>; </code>              || Show the format of the table
|-
|-
| <source lang="mysql"> CREATE DATABASE <db_name>; </source>        || Create a database
| <code> CREATE DATABASE <db_name>; </code>        || Create a database
|}
|}


== User Accounts ==
== User Accounts ==

Navigation menu