MySQL Intro

Introduction to MySQL.

MySQL Introduction

MySQL is a widely used relational database management system (RDBMS).

MySQL is free and open-source.

MySQL is ideal for both small and large applications.

What is MySQL?

  • MySQL is a relational database management system
  • MySQL is open-source
  • MySQL is free
  • MySQL is very fast, reliable, scalable, and easy to use
  • MySQL uses standard SQL
  • MySQL compiles on a number of platforms
  • MySQL is compliant with the ANSI SQL standard
  • MySQL was developed, distributed, and supported by Oracle Corporation
  • The name is named after co-founder Michael Widenius's daughter, My

Data in MySQL

MySQL stores data in tables. A table is a collection of related data, and it consists of columns and rows.

Databases are useful for storing information categorically. A company may have a database with the following tables:

  • Employees
  • Products
  • Customers
  • Orders

Example

SELECT * FROM Customers;