Raspberry Pi_Eng_24.2.1 Relational Database and SQL


Published Book on Amazon


All of IOT Starting with the Latest Raspberry Pi from Beginner to Advanced – Volume 1
All of IOT Starting with the Latest Raspberry Pi from Beginner to Advanced – Volume 2


출판된 한글판 도서


최신 라즈베리파이(Raspberry Pi)로 시작하는 사물인터넷(IOT)의 모든 것 – 초보에서 고급까지 (상)
최신 라즈베리파이(Raspberry Pi)로 시작하는 사물인터넷(IOT)의 모든 것 – 초보에서 고급까지 (하)


Original Book Contents


24.2   MySQL Database

 

24.2.1  Relational Database and SQL

 

24.2.1.1    Relational database

 

The database is a tool to provide a function that stores and manages many complicated data systematically and search the data in various formats easily later.

 

There are many types of databases, but the type of most databases that are most popular in the world is relational database. Relational database is that many of datas in it are not simply managed as independent data, but rather that the data are systematically managed in relation to each other. The relationship between these data is defined at the same time when defining the form of the data in advance, and the data is managed according to the defined relationship and provides various functions.

 

24.2.1.2    Introduction and Features of MySQL

 

MySQL is used as a database in LAMP combinations.

 

MySQL is open source software that is free to use by default, and various open source tools associated with MySQL can also be used together.

 

MySQL is a relational database system and uses SQL to manage internal data.

 

Though MySQL is free, it is a tool to provide powerful function that is as good as any database, so it is used to build many web sites around the world.

 

For more detailed information on MySQL, please refer to the followings:

    http://www.mysql.com/