MySQL Cheat Sheet

mysql-cheatsheet.md

MySQL Cheat Sheet

connect to MySQL as a root

$ mysql -u root -proot

show the list of databases

mysql> show databases;

use the database db_name

mysql> use db_name;

connect to database db_name as a root

$ mysql -u root -proot db_name

show the list of tables in current database

mysql> show tables;

display the structure of the table table_name

mysql> describe table_name;