Category：MySql
-
Time：2019-8-24
This article shares the specific code of importing CSV files into MySQL using Navicat for your reference. The details are as follows. 1. Open navicat, connect to the database and find the tables you want to import. The database table is under the table under the specified database. 2. Right-click on the data sheet. Click […]
-
Time：2019-8-24
In our practical work, most people will encounter SQL optimization problems. This article mainly introduces the relevance of SQL optimization. First of all, how can we find that our SQL execution efficiency is low? The simplest way is that when the user feedback is slow, we will know where there may be SQL efficiency impact. […]
-
Time：2019-8-23
This article shares the specific code of Navicat for MySql visual import CSV file for your reference. The details are as follows. Version number:Navicate 12 1. Create a database, right-click the table and import wizard. 2. Select the format of the imported data file, next – >. 3. Choose the. CSV file to import. Pay […]
-
Time：2019-8-23
<1> Concept It is a restriction that restricts the data of rows and columns in a table to ensure the integrity and uniqueness of the data in the table. <2> Use scenarios When creating tables, add constraints < 3 > Classification 1. default: Default constraints, domain integrity 2. Not null: Non-null constraints, domain integrity 3. […]
-
Time：2019-8-22
This article shares with you the specific method of importing Chinese data of CSV from Navicat for SQLite. For your reference, the details are as follows. 1. Open the CSV file with Notepad++, click the menu [encoding] [to UTF-8 encoding], and save. 2. Select “Import Wizard” in Navicat for SQLite, import step by step according […]
-
Time：2019-8-22
ERROR 1698 (28000): Access denied for user [email protected] error My operating system is ubuntu: My MySQL version is: After installation, the following errors occurred when you logged in to mysql: Because no password was set during installation, the password may be empty, but MySQL can’t be entered anyway. So what to do? First step […]
-
Time：2019-8-21
This article shares how to use Navicat to import CSV data into MySQL for your reference. The details are as follows. 1. Get CSV data and save excel as CSV with office save as function. (Of course, this is the reason why my own data exists in excel, if you are CSV data, ignore this […]
-
Time：2019-8-21
This post refers to the installation steps of the website <https://blog.csdn.net/lx318/article/details/82686925> and corrects some installation problems of version 8.0.16. Installation in MySQL Version 8.0.16 may result in some errors indicating that “UTF8B4” was used instead of “UTF8B3”. #///////////////////// Here’s what’s in my. ini////////////////////// [mysqld] # Setting up port 3306 port=3306 # […]
-
Time：2019-8-20
Sometimes we need to import some data from other libraries into another library, which is stored in CSV files. For MySql databases, we have two ways: one is to import commands, the other is that many MySql clients (such as Heidisql, Sequel pro) provide us with such functions. Next, we will introduce two different ways […]
-
Time：2019-8-20
Connecting database and other basic operations, please solve it by yourself. This article focuses on recording how to change the password. 1. Query the user password: Query user password command: select host, user, authentication_string from mysql.user ; host：Ip’location’% which allows users to log in indicates that they can be remote; User: the user […]
-
Time：2019-8-19
Sometimes, in order to facilitate data export and import into SQL, we can use certain tools to facilitate the migration of our team’s database, which can achieve twice the result with half the effort. Here, I will give you a brief introduction of a data that can easily export or import MySQL. First, select the […]
-
Time：2019-8-19
Left join (left join) returns records that include all records in the left table and join fields equal in the right tableRight join (right join) returns all records that include all records in the right table and those that contain the same join fields in the left table.Inner join (equivalent join) returns only rows with […]
