MySQL Cheetsheet

Contents

• Database Related SQL commands

  • SHOW DATABASES
  • CREATE DATABASE <database>
  • SELECT DATABASE()
  • USE <database>
  • DROP DATABASE <database>

• Table Related SQL commands

  • SHOW TABLES
  • CREATE TABLE
  • DESC <table>
  • ALTER TABLE <table> ADD <column><column definition>
  • ALTER TABLE <table> ADD FOREIGN KEY (<field>) references <referenced table>(<referenced field>)
  • DROP TABLE <table>

• Row/Record Related SQL commands

  • INSERT INTO <table> (<field>, <field>, ...) VALUES (<value>,<value>,...)
  • SELECT <field>,<field>,... FROM <table> WHERE <conditions>
  • UPDATE <table> SET <field>='<value>'
  • DELETE FROM <table> WHERE <conditions>
  • SELECT * FROM <table> JOIN <another table> ON <conditionals>
  • SELECT * FROM <table> GROUP BY <field>
  • SELECT * FROM <table> ORDER BY <field>

• User Related SQL commands

  • CREATE USER
  • GRANT