2,187
edits
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 | ! Command !! Description | ||
|- | |- | ||
| < | | <source lang="mysql"> SHOW DATABASES; </source> || Show databases on server | ||
|- | |- | ||
| < | | <source lang="mysql"> USE <db_name>; </source> || Use / go into a database | ||
|- | |- | ||
| < | | <source lang="mysql"> SHOW TABLES; </source> || Show tables in current database | ||
|- | |- | ||
| < | | <source lang="mysql"> DESCRIBE <tbl_name>; </source> || Show the format of the table | ||
|- | |- | ||
| < | | <source lang="mysql"> CREATE DATABASE <db_name>; </source> || Create a database | ||
|} | |} | ||
== User Accounts == | == User Accounts == |