Category:MySql
-
Time:2019-12-15
MySQL create user and authorization Privilege management We know that our highest authority manager is root, which has the highest authority operation. Including select, update, delete, update, grant and other operations. In general, DBA engineers will create a user and password after the company, let you connect to the database operation, and set the permissions […]
-
Time:2019-12-15
Summary In the database, the index is used to speed up the data search just like the tree directory. For an SQL query operation, quickly filter out the data that does not meet the requirements and locate the data that meets the requirements according to the index, so that the entire table does not need […]
-
Time:2019-12-14
I. installation and deletionInstallationSudo apt get updateSudo apt get install MySQL server Delete sudo apt-get autoremove mysql-\* –purge(a prompt box will pop up, indicating whether to delete the data (after deletion, the data will be lost, please pay attention to backup). Select Yes) Two, use1. Log in to MySQLNote that users will be denied access […]
-
Time:2019-12-14
Multiway search tree Height of complete binary tree: O (log2n), where 2 is logarithm The height of the complete m-path search tree: O (logmn), where m is the logarithm and the number of nodes in each layer of the tree M-path search tree is mainly used to solve the problem of data storage which can […]
-
Time:2019-12-13
Learning content 1. Software installation and server settings. 2. (optional, but strongly recommended) use the graphical interface software Navicat for SQL 3. Basic knowledge of database Database definition Relational database Two-dimensional table That’s ok column Primary key Foreign key 4. MySQL database management system data base Data sheet view stored procedure Software installation MySQL download […]
-
Time:2019-12-13
Usually every developer will discuss the optimization of SQL when there is a large amount of data. But not everyone will have 100W of data to be used in actual combat, so today we will simulate a 100W data table by ourselves. Creating principle In fact, there are many ways to create, fast and slow. […]
-
Time:2019-12-12
Indexes I. Introduction to index A data structure in a database that is designed to help users quickly find data. Similar to the directory in a dictionary, can you find the storage location of data according to the directory when looking up the contents of the dictionary, and then get it directly. II. Function of […]
-
Time:2019-12-12
Yesterday, I bought a year’s Alibaba cloud server. The system is Linux centos7, and I installed a MySQL with great expectation. The next day, I almost doubted my life… How to install MySQL is not much to say. Anyway, I have installed it three times, and I can connect to the database locally on Alibaba […]
-
Time:2019-12-11
I. Introduction to MySQL official website 1. Developer zone: MySQL development engineer Articles: Oracle Engineer’s own blogPlant MySQL: blog for MySQL related practitioners Bugs : MySQL BugListWorklog: development recordLabs: MySQL experimental project 2. Downloads: MySQL Download Enterprise: MySQL enterprise version related, skipCommunity: community version, we download and use the community version MySQL Community Server : […]
-
Time:2019-12-11
Install 8.0.13 based on MySQL 6.1.3 MySQL 8.0.13 download address: https://dev.mysql.com/downloads/windows/installer/8.0.html The. MSI file of 313.8m can be downloaded directly. After downloading, it is shown as follows: Double click to install directly. If the following error is reported, the corresponding. Net framework can be updated in 360 Agree to go to the next step Next, […]
-
Time:2019-12-10
New databases emerge in endlessly, MySQL looks like a declining mountain. In fact, there are many people who prefer or use legacy systems and still live in the MySQL world.I haven’t used it for a long time. It’s been more than ten years.But a few days ago, a friend asked me to help them upgrade […]
-
Time:2019-12-10
Linux virtual machine: VMware + Ubuntu 16.04.4 Windows native: Navicat for MySQL 1. Download and install MySQL in virtual machine For VMware download and installation and Ubuntu 16.04.4 download and installation, please check with Baidu. By default, these have been installed. In the virtual machine, open a terminal by Ctrl + Alt + T, enter […]