2,187
edits
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 | ! 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 | ||
|} | |} | ||
== User Accounts == | == User Accounts == |