MySQL Basic Commands

I am really bad with memorization, so this blog post will serve as a reference to the basic MySQL syntax I use in the class.

To install MySQL in Ubuntu, follow this guide.

PS: Most MySQL commands are capitalized to differentiate between the syntax and field names.

  • Starting MySQL – sudo /usr/bin/mysql -u root -p

  • Show list of databases – SHOW DATABASES;

  • Create a database – CREATE DATABASE [database name];

  • Deleting a database – DROP DATABASE [database name];

  • Select a database – USE [database name];

  • Creating a table – CREATE TABLE [table name] (fieldName datatype(length), … );

  • Deleting a table – DROP TABLE [table name];

  • See all the tables in a database – SHOW TABLES;

  • Describe field formats in a table – DESCRIBE [table name];

  • Rename a table – RENAME TABLE [old name] TO [new name];

  • I will keep updating it as I learn new commands. Peace out.