当前位置:网站首页>[simple understanding of database]
[simple understanding of database]
2022-04-23 17:11:00 【ZHZHK001】
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
=======================================================================
版权声明
本文为[ZHZHK001]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230553251452.html
边栏推荐
- Detailed explanation of Milvus 2.0 quality assurance system
- Grpc gateway based on Ocelot
- Clickhouse table engine
- Multithreaded @ async thread pool
- Using quartz under. Net core - calendar of [6] jobs and triggers
- Shell-sed命令的使用
- [problem solving] [show2012] random tree
- Self use learning notes - connectingstring configuration
- .Net Core3. 1 use razorengine NETCORE production entity generator (MVC web version)
- Use of shell awk command
猜你喜欢
[PROJECT] small hat takeout (8)
Further study of data visualization
Using quartz under. Net core -- job attributes and exceptions of [4] jobs and triggers
ASP. Net core JWT certification
Shell script -- shell programming specification and variables
基于51单片机红外无线通讯仿真
Detailed explanation of Milvus 2.0 quality assurance system
【生活中的逻辑谬误】稻草人谬误和无力反驳不算证明
JS, entries(), keys(), values(), some(), object Assign() traversal array usage
Simulation of infrared wireless communication based on 51 single chip microcomputer
随机推荐
Clickhouse SQL operation
Milvus 2.0 détails du système d'assurance de la qualité
First knowledge of go language
Bottom processing of stack memory in browser
1-3 nodejs installation list configuration and project environment
matlab如何绘制已知公式的曲线图,Excel怎么绘制函数曲线图像?
Net standard
JS to find the character that appears three times in the string
Blue Bridge Cup provincial road 06 -- the second game of the 12th provincial competition
ClickHouse-表引擎
Promise (II)
On lambda powertools typescript
Use of shell awk command
Production environment——
Error in v-on handler: "typeerror: cannot read property 'resetfields' of undefined"
EF core in ASP Generate core priority database based on net entity model
【生活中的逻辑谬误】稻草人谬误和无力反驳不算证明
C语言函数详解
Baidu Map Case - modify map style
AIOT产业技术全景结构-数字化架构设计(8)