Difference between revisions of "MySQL"

Jump to navigation Jump to search
100 bytes added ,  14:50, 18 January 2010
m
→‎Basic Commands: Added SyntaxHighlight
m (→‎Display Users: Added SyntaxHighlight)
m (→‎Basic Commands: Added SyntaxHighlight)
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
|-
|-
| <code> SHOW DATABASES; </code>                  || Show databases on server
| <source lang="mysql"> SHOW DATABASES; </source>                  || Show databases on server
|-
|-
| <code> USE <db_name>; </code>                    || Use / go into a database
| <source lang="mysql"> USE <db_name>; </source>                    || Use / go into a database
|-
|-
| <code> SHOW TABLES; </code>                      || Show tables in current database
| <source lang="mysql"> SHOW TABLES; </source>                      || Show tables in current database
|-
|-
| <code> DESCRIBE <tbl_name>; </code>              || Show the format of the table
| <source lang="mysql"> DESCRIBE <tbl_name>; </source>              || Show the format of the table
|-
|-
| <code> CREATE DATABASE <db_name>; </code>        || Create a database
| <source lang="mysql"> CREATE DATABASE <db_name>; </source>        || Create a database
|}
|}


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

Navigation menu