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