MySQL is a Database Management System (DBMS) for relational databases. Thus, this is nothing more than an application that allows you to manage files called databases. There are many types of databases, from a simple file to object-oriented relational systems. As a relational database, uses multiple tables to store and organize information. MySQL was written in C and C ++ and stands out for its great adaptation to different development environments, allowing its interaction with the most used programming languages ​​such as PHP, Perl and Java and its integration in different operating systems.

A database is simply a collection of structured data. The 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.

This originally was developed in 1994. US technology company Sun Microsystems then took full control when it bought in 2008. US tech giant Oracle acquired Sun Microsystems in 2010, and MySQL has been owned by Oracle since then.

MySQL Features

It was originally developed in 1994. US technology company Sun Microsystems then took full control when it bought MySQL in 2008. US tech giant Oracle acquired Sun Microsystems in 2010, and MySQL has been owned by Oracle since then.

Without getting too deep into technical issues, the main processes that take place in a MySQL environment are the same, and they are:

This was create as a database to store and manipulate data, defining the relationship of each table.

Clients can make requests by writing specific SQL statements in MySQL.

The server application will respond with the requested information and this will appear in front of the clients.

See also:
PHP – general purpose programming language
What should we know about security with JavaScript


Por Truxgo

Un comentario en «MySQL – Database administration»

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

This will close in 0 seconds