Simple MySQL Commands Cheat sheet

Commands Access monitor: mysql -u [username] -p; (will prompt for password) Show all databases: show databases; Access database: mysql -u [username] -p [database] (will prompt for password) Create new database: create database [database]; Select database: use [database]; Show all tables: show tables; Show table structure: describe [table]; Create new table with columns: CREATE TABLE [table]… Read more Simple MySQL Commands Cheat sheet