2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
Added "Basic Commands"
m (Added category) |
m (Added "Basic Commands") |
||
| Line 1: | Line 1: | ||
== Basic Commands == | |||
{|cellpadding="4" cellspacing="0" border="1" | |||
|- style="background-color:#bbddff;" | |||
! 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 == | ||
=== Create Users === | === Create Users === | ||