What is MYSql? Detailed explanation for beginners

A Swedish company called MySQL AB originally developed MySQL in 1994. The US technology company Sun Microsystems then took full control when it bought MySQL AB in 2008. The American technology giant Oracle acquired Sun Microsystems in 2010, and MySQL has been owned by Oracle since then.

MySQL runs on virtually all platforms, including Linux, UNIX and Windows. Although it can be used in a wide range of applications, MySQL is more associated with web-based applications and online publishing and is an important component of an open source business stack called LAMP. LAMP is a web development platform that uses Linux as an operating system, Apache as a web server, MySQL as a relational database management system and PHP as an object-oriented programming language (sometimes, Perl or Python is used instead of PHP)

Database: database is simply a collection of structured data. Imagine you take a selfie: you press a button and capture an image of yourself. Your photo is information and your phone’s gallery is the database. A database is a place where data is stored and organized. The word “relational” means that the data stored in the data set is organized in the form of tables. Each table is related in some way. If the software is not compatible with the relational data model, it is simply called DBMS.

Client-server model: he computers that have RDBMS software installed and run are called clients. Whenever they need to access the data, they connect to the RDBMS server. That is the “client-server” part.

MySQL is one of the many RDBMS software options. It is often thought that RDBMS and MySQL are the same due to the popularity of MySQL. To name some great web applications like Facebook, Twitter, YouTube, Google and Yahoo !, they all use MySQL for data storage. Although initially created for limited use, it is now compatible with many important computing platforms such as Linux, macOS, Microsoft Windows and Ubuntu.

SQL : MySQL and SQL are not the same. Keep in mind that MySQL is one of the most popular RDBMS software brands, which implements a client-server model. So how do the client and server communicate in an RDBMS environment? They use a domain-specific language: structured query language (SQL, Structured Query Language). When you see other names that contain SQL, such as PostgreSQL and the Microsoft SQL server, it is very likely that they are marks that also use the SQL syntax. RDBMS software is often written in other programming languages, but always uses SQL as the primary language to interact with the database. MySQL as such is written in C and C ++. As with the South American countries, they are all geographically different and have different stories, but they all speak mainly Spanish.

History aside, SQL tells the server what to do with the data. It is similar to your password or WordPress code. You enter it in the system to get access to the control panel area. In this case, the SQL statements can tell the server to perform certain operations:

Data consultation: request specific information from the existing database.

Data manipulation: add, delete, change, sort and other operations to modify data, values ​​or visual elements.

Data identity: define data types, for example, change numerical data to whole numbers. This also includes the definition of a scheme or the relationship of each table in the database.

Data access control: provide security techniques to protect data, including deciding who can see or use any information stored in the database.