MySQL is the world's most popular open source free database management system and is popular among developers during application development. Because MySQL is a high-speed, stable, and easy-to-use database, it is portable, works on multiple operating systems that provide a large system of very powerful utility functions. With high speed and security, MySQL is suitable for applications that access databases on the internet.
A Database is a separate application that stores a data set. Each database has one or more separate APIs to create, access, manage, search, and replicate the data it holds.
Some other types of data stores can be used, such as files on file systems or large Hash Tables, but data capture and recording cannot be quick and easy with these types of data stores. systems.
So, today, we use Relational Database Management Systems (RDBMS) to store and manage large amounts of data. It is called a relational database, because all data is stored in different data tables and relationships established by using Primary Key and some other keys. known as Foreign Key.
A relational database management system (RDBMS) is a software that:
Gives you the ability to deploy a Database with data tables, columns (columns), and indexes (Index).
Ensure that the Referential Integrity (can translate as relationship integrity) between the various rows and tables.
Automatically update the index.
Interpret an SQL query and combine information from different tables.
Before going into the MySQL database system concept, let's review some database related definitions:
Database: A database is a collection of data tables, with related data.
Data table: A table is a data matrix. A table in a database looks like a simple spreadsheet.
Column: A column contains the same data type, such as a customer name.
Item: A row (row, entry, record) is a group of related data.
Redundancy: (can be interpreted as redundant data) Data is stored twice, to make the system faster.
Primary Key: A Primary Key is unique. A key value cannot appear twice in a table. With a key, you can find the majority on a row.
Foreign Key: You imagine Foreign Key as a pin between two tables.
Compound Key: A Compound Key (or composite key) is a key that consists of multiple columns, because a column is not unique.
Index: An index in a database similar to the index in a book.
Referential Integrity: Make sure that a Foreign Key value always points to an existing row.
What is MySQL?
MySQL is a fast and easy to use RDBMS. MySQL is being used for many large and small businesses. MySQL developed, published, supported by MySQL AB, is a Swedish company. MySQL has become quite popular for many reasons:
MySQL is open code. So, to use it, you don't have to spend a penny.
MySQL is a very powerful program.
MySQL uses a standard form of well-known data language that is SQL.
MySQL works on many operating systems and in many languages such as PHP, PERL, C, C ++, Java, ...
MySQL works fast and healthy even with large data sets.
MySQL is very friendly with PHP, a very valuable language to learn about Web development.
MySQL supports large databases, up to 50 million rows or more in a table. The default file size is limited to 4 GB, but you can increase this size (if your operating system can handle it) to reach the theoretical limit of 8 TB.
MySQL is adjustable. Open source GPL licenses allow programmers to modify MySQL software to suit their specific environment.