This is the first day of my participation in the August More text Challenge. For details, see: August More Text Challenge
Hello everyone, I’m [Bean Dry peanut], today I’m going to share SQL, mysql, Navicat install in one step
Mysql is a very common tool, but for beginners, installing a complete environment can be a hassle. Today we will talk about what SQL is, how to install mysql, and how to install navicat, the database visualization software.
This is my study note for learning SQL /mysql from scratch and will be updated later.
Record their own technical growth, also hope to share with you exchanges, welcome to pay attention ~
The basic concept
1.sql
The Structured Query Language (SQL) is a special purpose programming Language. It is a database Query and programming Language used to access data and Query, update, and manage relational database systems.
Structured query Language is a high-level, non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structure can use the same structured query language as the interface of data input and management. Structured query Language statements can be nested, which gives it great flexibility and power.
SQL is widely used for various database operations.
2.mysql
MySQL is a relational database management system developed by MySQL AB in Sweden and a product of Oracle. MySQL is one of the most popular Relational Database Management systems and one of the best RDBMS (Relational Database Management System) applications for WEB applications.
MySQL is a relational database management system, and relational databases store data in different tables, rather than having all the data in one large warehouse, which increases speed and flexibility.
The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts dual authorization policy, which is divided into community edition and commercial edition. Due to its small size, fast speed, low overall cost of ownership, especially the characteristics of open source, the development of small and medium-sized websites generally choose MySQL as the website database.
The advantages of MySQL
1, mysql performance is excellent, stable service, rarely abnormal downtime.
2. Mysql is an open source code with no copyright restriction, autonomy and low use cost.
3. Mysql has a long history, and its community and users are very active. If you encounter problems, you can ask for help.
3.navicat
Navicat is a fast, reliable and affordable database management tool designed to simplify database management and reduce system administration costs. It is designed to meet the needs of database administrators, developers and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access, and share information in a secure and simple way.
Navicat Premium is a multi-connection database management tool that allows you to connect to MySQL, Oracle, PostgreSQL, SQLite, and SQL Server databases in a single program, making it easier to manage different types of databases. Navicat Premium combines the capabilities of other Navicat members. Navicat Premium supports data transfer between MySQL, Oracle, PostgreSQL, SQLite, and SQL Server with the ability to connect to different database types. It supports most of the functions of MySQL, Oracle, PostgreSQL, SQLite, and SQL Server.
In summary, SQL is the operating language, mysql is the underlying database, and Navicat is the visualization software for the database.
uninstall
Uninstall mysql and SQL Server first
It’s troublesome…
Uninstall with 360 Software Manager first, and then use steps 4.5.6 of the following tutorial:
Blog.csdn.net/weixin_4381…
Restart the computer
The installation
Just follow that exactly
Blog.csdn.net/O8088/artic…
Use Navicat visualization software
Navicat has been installed before
To connect mysql to Navicat, follow the following steps on the blog:
Blog.csdn.net/qq_43715354…
Select mysql and set:
Navicat is simple to use
Check out the following blogs:
Blog.csdn.net/qq_45069279…
The SQL file used for the demonstration is as follows:
Download.csdn.net/download/de…
As follows:
The effect is as follows:
Mysql statement use (included in terminal use)
Blog.csdn.net/qq_45069279…
Code word is not easy to see here as a like oh ~ just to the nuggets, after the previous articles will be highly praised to move here, welcome to pay attention to me oh ~ now attention is the old powder it ~
