MySQL Tutorial

MySQL is an RDBMS (Relational DataBase Management System). It is based on SQL (Structured Query Language). It is one of the most popular and most used Open Source RDBMS and works on most of the system platforms. Proprietary Enterprise Edition is also available from Oracle with paid support via MySQL Enterprise products.

MySQL Tutorial

• MySQL Shell

  • MySQL Tutorial – Login to MySQL Command Line Interface
  • MySQL Tutorial – Get list of all Users
  • MySQL Tutorial – Get list of Connected Users

• MySQL DATABASE

  • MySQL Tutorial – CREATE database
  • MySQL Tutorial – USE database
  • MySQL Tutorial – SHOW databases
  • MySQL Tutorial – DELETE database

• MySQL TABLE

  • MySQL Tutorial – CREATE Table
  • MySQL Tutorial – Rename Table
  • MySQL Tutorial – Duplicate Table
  • MySQL Tutorial – Add a new Column to Table
  • MySQL Tutorial – Rename Column of Table
  • MySQL Tutorial – Delete or Drop a column from Table
  • MySQL Tutorial – Select Distinct Values of Column
  • MySQL Tutorial – Count number of rows in Table
  • MySQL Tutorial – Increase Column Size
  • MySQL Tutorial – Add an AUTO_INCREMENT column as PRIMARY KEY
  • MySQL Tutorial – Add column to Index
  • MySQL Tutorial – Delete or Drop column from Index
  • MySQL Tutorial – SHOW INDEX of Table