current position:Home>Mysql database interview questions & knowledge points summary (2021 latest version) | javaguide

Mysql database interview questions & knowledge points summary (2021 latest version) | javaguide

2022-01-27 00:16:53 JavaGuide

MySQL Basics

Introduction to relational database

seeing the name of a thing one thinks of its function , Relational database is a kind of database based on relational model . The relational model shows the relationship between the data stored in the database ( one-on-one 、 One to many 、 Many to many ).

In relational database , Our data is stored in various tables ( For example, user table ), Each row in the table holds one piece of data ( Like a user's information ).

Most relational databases use SQL To manipulate the data in the database . also , Most relational databases support the four features of transactions (ACID).

What are the common relational databases ?

MySQL、PostgreSQL、Oracle、SQL Server、SQLite( Wechat is used to store local chat records SQLite) ….

MySQL Introduce

MySQL It's a relational database , It is mainly used for persistent storage of some data in our system, such as user information .

because MySQL Open source, free and relatively mature database , therefore ,MySQL It is widely used in various systems . Anyone can be in GPL(General Public License) Download and modify it according to the needs of personalization .MySQL The default port number for is 3306.

Storage engine

copyright notice
author[JavaGuide],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/01/202201270016515159.html

Random recommended