[go: up one dir, main page]
Scribd
Upload
12 views7 pages

What Is MySQL and How Does It Work

MySQL is an open-source Relational Database Management System (RDBMS) used for efficiently storing, managing, and retrieving structured data across various applications. It operates on a client-server model where clients connect to the MySQL server using Structured Query Language (SQL) for data operations. MySQL is compatible with multiple computing platforms and allows users to modify its source code to meet specific needs.

Uploaded by

damodar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
12 views7 pages

What Is MySQL and How Does It Work

MySQL is an open-source Relational Database Management System (RDBMS) used for efficiently storing, managing, and retrieving structured data across various applications. It operates on a client-server model where clients connect to the MySQL server using Structured Query Language (SQL) for data operations. MySQL is compatible with multiple computing platforms and allows users to modify its source code to meet specific needs.

Uploaded by

damodar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 7

What Is MySQL and How Does It Work

Shashikant S K
What is MySQL

• MySQL is an open-source Relational Database


Management System (RDBMS) that enables
users to store, manage, and retrieve
structured data efficiently. It is widely used for
various applications, from small-scale projects
to large-scale websites and enterprise-level
solutions.
Client-Server Model

• Computers that install and run RDBMS software are


called clients. Whenever they need to access data, they
connect to the RDBMS server.
• MySQL is one of many RDBMS software options. RDBMS
and MySQL are often thought to be the same because of
MySQL’s popularity. A few big web applications like
Facebook, Twitter, YouTube, Google, and Yahoo! all use
MySQL for data storage purposes. Even though it was
initially created for limited usage, it is now compatible
with many important computing platforms like Linux,
macOS, Microsoft Windows, and Ubuntu.
SQL

• MySQL and SQL are not the same. Be aware


that MySQL is one of the most popular RDBMS
software’s brand names, which implements a
client-server model.
• The client and server use a domain-specific
language – Structured Query Language (SQL)
to communicate in an RDBMS environment.
SQL
SQL tells the server what to do with the data. In this case, SQL
statements can instruct the server to perform certain operations:

• Data query – requesting specific information from the existing


database.
• Data manipulation – adding, deleting, changing, sorting, and other
operations to modify the data, the values or the visuals.
• Data identity – defining data types, e.g. changing numerical data to
integers. This also includes defining a schema or the relationship of
each table in the database
• Data access control – providing security techniques to protect data.
This includes deciding who can view or use any information stored in
the database
Open-Source

• Open-source means that you’re free to use


and modify it. You can also learn and
customize the source code to better
accommodate your needs.
How Does MySQL Work?

The basic structure of the client-server structure involves


one or more devices connected to a server through a
specific network.
• MySQL creates a database for storing and manipulating
data, defining the relationship of each table.
• Clients can make requests by typing specific SQL
statements on MySQL.
• The server application will respond with the requested
information, and it will appear on the client’s side.

You might also like