From vWiki
Jump to: navigation, 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


This category has only the following subcategory.