MySQL general usage snippets – connecting, listing, creating and deleting databases

Connect to mysql server

mysql -h localhost -u root -p

List databases

show databases;

Create a database

create database mydb;

Delete a database

drop database mydb;

Select a working database

use mydb;

Show all tables in database

show tables;

See table structure

describe table_name;

Show all rows in a table

SELECT * FROM table_name;

Get 30 results, order by id column (last in first)

SELECT * FROM table_name ORDER BY id DESC LIMIT 30;

Select row by value of a column

SELECT * FROM table_name WHERE table_field = 'meatballs';