---

Look at the great God comment , I selectively add
Too complicated , Even if it's too professional
Programming beginners don't just , The level is very low , I hope someone can answer 、 Add .
Update time ：2021-12-30

---

=======================================================================

mysql

MYSQL Is a perfect server database . Comprehensive function , Integration , Pursue maximum concurrency efficiency
Large amount of data 、 Multi function , Need to install

System requirements

It takes... To install Space 【 edition -- 】
The requirements for hardware are relatively low

Data backup and restore

Generally use tools or commands for backup

You can also use the folder method to back up and restore data , It will be more troublesome to operate , Looks like we need two computers mysql Consistent configuration , Never used

application

Website, etc

rest

It seems that there is also a table space , Not enough technology , Think about it later

Start using ( For the first time )

1、 New database

CREATE DATABASE K01;
--( Note that the last semicolon is required for some occasions )【Navicat There is no semicolon in , It is also possible to execute after selecting 】
--  This statement needs to be upgraded   Need to add UTF-8, Sorting also needs to specify 

2、 A new user

CREATE USER 'K001'@'localhost' IDENTIFIED BY 'K0001';
-- user name K001
--localhost Represents a local user 
-- password K0001

3、 Authorized users can use the established database

grant all on K01.* to 'K001'@'localhost' identified by 'K0001';
-- database K01
-- user name K001
-- password K0001
-- The authorized content is all permissions 

4、 Build table

=======================================================================

Oracle

Large amount of data 、 Multi function , Need to install

System requirements

It takes... To install 5 individual G Space –11G edition
There are certain requirements for computer configuration

cost

The database is free –11G

Table space – surface -- Field
user

Data backup and restore

The database data file cannot be simply realized by copying the database file
For general data migration, use the command 、 Use tools to achieve

application

Website 、 Banks, etc

Start using ( For the first time )

1、 New tablespace

2、 A new user

3、 Authorization management

4、 Build table ……

=======================================================================

sqlite

It's a file database , Everything , It's all in one file
Not protected by copyright

Can be simple , miniaturization , Pursue maximum disk efficiency
sqlite Is a small database , Simple, portable, no installation, just a few files .

System requirements

It takes... To install 131M Space
Low requirements for hardware

cost

The database is free

Tools ：
sqliteexpert There are professional version and paid version
Navicat It can also be used

And Oracle Comparison

sqlite The database doesn't have anything like Oracle Users of 、 Table space or something
sqlite New database Can't design the password when opening , Data is transparent , Anyone can open it , Low safety performance
And Oracle、MySQL、SQL Server When the database is different , It can be embedded in the program , Is an integral part of the program

Data backup and restore

as long as Database file replication Then it can be easily reused
Not affected by the operating system 、 The impact of configuration

Reinstall the system , As long as the data file is
As long as the corresponding version of database software is also installed , Can open data files

application

General cell phones , Terminals are used more
When learning programming, you can use , After all, database files are easy to submit to teachers for viewing

Start using ( For the first time )

1、 Create a new database file

– password-less No users No tablespace There are database files No database selection
2、 Build table

=======================================================================

Access

Large amount of data 、 Multi function , Need to install
It seems that you can also learn from excel Read data from , I don't know how to update data ！ It should be possible

System requirements

It takes... To install Space 【 edition -- 】
The requirements for hardware depend on the software version ,access2003、2007 Lower requirements for computers

And sqlite Comparison

sqlite Database has no password
access You can set the password

Data backup and restore

As long as the database file is copied, it can be easily reused
Not affected by the operating system 、 The impact of configuration

Reinstall the system , As long as the data file is
As long as the corresponding version of database software is also installed , Can open data files

application

Website, etc

=======================================================================

Excel

There is a limit on the number of lines
xls----------65536 That's ok --------6W
xlsx-----1048576 That's ok -----100W【2007 And above 】

System requirements

It takes... To install Space 【 edition -- 】
The computer is basically OK , The hardware requirements are not high

cost

WPS It's free. , Many specific functions need to be charged
Msoffice Is the charge
Many free software also use this format , evermore office、openoffice

A file , The data is all in it
Direct copy 、 edit 、 open
But how to add, delete, change and check in the program , I haven't thought about how to write code yet ！

Data backup and restore

As long as the database file is copied, it can be easily reused
Not affected by the operating system 、 The impact of configuration
Reinstall the system , As long as the data file is
As long as the corresponding version of database software is also installed , Can open data files
According to the distribution of 、 share 、 Printing is very convenient

application

Office software

=======================================================================

SQL Server

No contact with For the time being

=======================================================================