MySQL Commands

There are many sites that will provide far greater detail and comment than this one. However, this is a list of basic commands that I have found repeatedly useful.

MySQL Commands

Create a database

create database databasename; 

List all databases
show databases;

Switch to a database
use databasename;

Show tables in a database
show tables;

Delete a database
drop database databasename;

Delete a table
drop table tablename;

Show data in a table
SELECT * FROM tablename;

Find a specific row from accounts with specific criteria.
SELECT * from ACCOUNTS where username = "";

Delete a row from accounts

DELETE from ACCOUNTS where username = "";