Mysql Cheatsheet

My mysql Cheat Sheet

mysql -u root

show databases;
// the default databases
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

//show the schema of a table
describe table_name;

create database db_name;
drop database db_name;

// unzip the db dump on mac 
gunzip ${db_name}.sql.gz

//seed a db dump file into mysql
mysql -u root ${db_name} < ${path/db_name}.sql

//create a database
mysqladmin -uroot create ${dbname}