From vWiki
Revision as of 23:10, 16 March 2014 by Sstrutt (talk | contribs) (Updated - MySQL page now subs off category)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

See the official MySQL documentation for further info.

Basic Commands

Command Description
SHOW DATABASES; Show databases on server
USE <db_name>; Use / go into a database
SHOW TABLES; Show tables in current database
DESCRIBE <tbl_name>; Show the format of the table
CREATE DATABASE <db_name>; Create a database
DROP DATABASE <db_name>; Drop (delete) a database