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 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

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

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments