当前位置:网站首页>[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
边栏推荐
- EF core in ASP Generate core priority database based on net entity model
- C语言函数详解
- freeCodeCamp----shape_ Calculator exercise
- Using quartz under. Net core - [1] quick start
- Detailed explanation of Milvus 2.0 quality assurance system
- TypeError: set_ figure_ params() got an unexpected keyword argument ‘figsize‘
- Handwritten event publish subscribe framework
- Milvus 2.0 質量保障系統詳解
- Webapi + form form upload file
- How does matlab draw the curve of known formula and how does excel draw the function curve image?
猜你喜欢
Further study of data visualization
oracle 中快速获取表的列名列表
EF core in ASP Generate core priority database based on net entity model
[WPF binding 3] listview basic binding and data template binding
Using quartz under. Net core -- job attributes and exceptions of [4] jobs and triggers
Nacos + aspnetcore + Ocelot actual combat code
VLAN高级技术,VLAN聚合,超级Super VLAN ,Sub VLAN
Deep understanding of control inversion and dependency injection
Change the password after installing MySQL in Linux
CentOS MySQL multi instance deployment
随机推荐
C dapper basically uses addition, deletion, modification and query transactions, etc
Devexpress GridView add select all columns
Using quartz under. Net core -- general properties and priority of triggers for [5] jobs and triggers
Understanding of RPC core concepts
1-1 NodeJS
Further optimize Baidu map data visualization
Redis docker installation
Use of shell cut command
JSON deserialize anonymous array / object
VLAN advanced technology, VLAN aggregation, super VLAN, sub VLAN
[C#] 彻底搞明白深拷贝
El cascade and El select click elsewhere to make the drop-down box disappear
Handwritten event publish subscribe framework
线性代数感悟之1
Use of shell sed command
【WPF绑定3】 ListView基础绑定和数据模板绑定
About stream flow, write it down briefly------
Solution architect's small bag - 5 types of architecture diagrams
[registration] tf54: engineer growth map and excellent R & D organization building
Conversion between hexadecimal numbers