Vol. 6 – No. 2, year (2022), page 2413-2417
| ISSN 2548-8201 (Print) | 2580-0469) (Online) |
Copyright © 2022 Edumaspul - Jurnal Pendidikan (ISSN 2548-8201 (cetak); (ISSN 2580-0469 (online)
Database Management in MYSQL
Jodi Wahyudi
1
, Masduki Asbari
2*
, Ipang Sasono
3
, Tias Pramono
4
, Dewiana Novitasari
5
1,2,3,4,5
Universitas Insan Pembangunan Indonesia, Indonesia
*Corresponding email: kangmasduki.ssi@gmail.com
Receive: 12/08/2022 Accepted: 11/09/2022 Published: 01/10/2022
Abstract
The purpose of this research is to find out what is database management in MySQL or read My Sequel
is a Database Management System often abbreviated as DBMS, MySQL is an open-source database
management system. MySQL can be used to create and manage databases and their contents, from
the smallest to the very large and to convey information to its users. MySQL is also included in the
RDBMS or Relational Database Management system, where in its database structure so that when the
data retrieval process uses the relational database method and becomes a liaison between the
software and the database server. The thing to remember is that MySQL can be used for free.
Keywords: Database, management, MySQL database.
Introduction
Before entering the MySQL database, we must
first know what the database means. The
database is known as a database, consisting of the
base and data of the word. Data is a record of a
collection of facts that represent an object. Data is
raw and has no context. While the base or base
can be interpreted as the headquarters, the
gathering place of an object or object
representation. The database is a collection of
data that are interconnected with one another,
stored on computer hardware, and used by
software to manipulate it. The database is one of
the important components in information
systems because it is the basis for providing
information to users. MySQL or read My Sequel is
a Database Management System often
abbreviated as DBMS, MySQL is an open-source
database management system. MySQL is a
compatible partner of PHP. MySQL is created and
developed by MySQL AB based in Sweden.
MySQL can be used to create and manage
databases and their contents. We can use MySQL
to add, modify and delete data in the database.
MySQL is a relational database management
system. This means that the data that is managed
in the database will be placed in several separate
tables so that data manipulation will be much
faster. MySQL can be used to manage databases
ranging from small to very large. MySQL can also
run Structured Query Language (SQL) commands
to manage the databases in it. Until now, MySQL
has grown to version 5. MySQL 5 already supports
triggers to facilitate the management of tables in
the database. MySQL is also included in the
RDBMS or Relational Database Management
system, where in its database structure so that
when the data retrieval process uses the relational
database method and becomes a liaison between
the software and the database server.
Method
The approach that the researcher uses in this
research is a descriptive qualitative approach
which explains that qualitative research is
research that produces descriptive data, namely
writing. Where this approach is expected to
produce an in-depth description of writing and
others that are studied from a complete point of
view.