MySQL Introduction

Introduction

What is MySQL?

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. (Source: Wikipedia)

With the this programming language, you can manage data stored in relational databases

What is Relational Database?

A relational database is a database that organizes information into one or more tables.

What is table?

A table is a collection of data organized into rows and columns. Tables are sometimes referred to as relations.

Here, we have a table called “Customer”.

Column

Column is the type of the data we will insert into our table. in our Customer table, the columns are id, balance and address are our column

Rows

A row is a single record in a table. The first row in the Customer table has:

Name: Alim
OD: 1001
Balance: $50,000
Address: Dhaka

What are the types of data we store in our database?

				
					•	INTEGER, a positive or negative whole number
•	TEXT, a text string
•	DATE, the date formatted as YYYY-MM-DD
•	REAL, a decimal value

Basic MySQL

MySQL Introduction

MySQL Create

MySQL Insert

MySQL Select

MySQL Alter

MySQL Update

MySQL Delete