Table of contents
MySQL is a Relational Database Management System.
MySQL is Open-Source.
MySQL is free.
MySQL is ideal for both small and large applications.
MySQL is very fast, reliable, scalable, and easy to use.
MySQL is cross-platform.
MySQL is compliant with the ANSI SQL standard.
MySQL was first released in 1995.
MySQL is developed, distributed, and supported by Oracle Corporation.
MySQL is named after co-founder Monty Widenius's daughter: My.
My SQL USED BY:
Huge websites like Facebook, Twitter, Airbnb, Booking.com, Uber, GitHub, YouTube, etc.
Content Management Systems like WordPress, Drupal, Joomla!, Contao, etc.
A very large number of web developers around the world.
To display data on the website:
An RDBMS database program (like MySQL).
A server-side scripting language, like PHP.
Use SQL to get the data you want.
To use HTML / CSS to style the page.
RDBMS uses SQL queries to access the data in the database.
RDBMS is the basis for all modern database systems such as MySQL, Microsoft SQL Server, Oracle, and Microsoft Access.
Database Table:
A table is a collection of related data entries, and it consists of columns and rows.
A column holds specific information about every record in the table.
A record (or row) is each entry that exists in a table.
Pic Credits: 👩💻 w3schools
Example
Database table with Rows and Columns Database (Customers)
Columns
CustomerID.
CustomerName.
ContactName.
Address.
City.
PostalCode.
Country.
Rows 5 - The table has 5 records.
My SQL is a Relational Database Management System so to perform CRUD operations we use SQL Language to write queries.
- SQL keywords are NOT case sensitive:
selectis the same asSELECT.
The semicolon after every statement is mandatory at the end of the query.
EX:
SELECT * FROM table_name;
So this blog came to an end for this topic.
In the next BLOG, I am going to discuss the commands and other concepts related to My SQL.
Let's catch up!!
Reach out at the below links:💥