MySQL.md

MySQL Cheat Sheet

MySQL is a relational database management system which, in July 2013, was the world's second most widely used and the most widely used open -- source client-server RDBMS source.

Starting the interactive shell

$ mysql -u <user> -p
$ mysql -u <user> -p <database-name>

Six prompts of MySQL

mysql> ready for new command
    -> waiting for next line of a command
    '> waiting for next line of a string started with apostrophe
    "> as above, but for double quote
    `> as above, but for back tick
   /*> as above, but for comment

Exiting the shell

mysql> quit

Creating a database

mysql> create database <name>;

Deleting a database

mysql> drop database <name>;

Show the databases available

mysql> show databases;

Selecting a database to work with

mysql> use <database-name>;

Listing the tables in a database

mysql> show tables;

Describing the format of a table

mysql> describe <table-name>;

Dropping (removing) tables

mysql> drop <table-name>;

Exporting (just) data from the database as inserts

$ mysqldump -u <username> -p --no-create-info <database-name> > output.sql

Exporting (just) the structure from the database as create statements

$ mysqldump -u <username> -p --no-data <database-name> > output.sql

Written by Stephen Moon ([email protected]), 2016