Category:MySql

  • Importing CSV files into MySQL using Navicat

    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 […]

  • SQL optimization

    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. […]

  • Navicat for MySql Visual Import CSV File

    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 […]

  • MySQL Database Note 4: MySQL Constraints

    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. […]

  • Method of Importing Chinese Data of CSV into Navicat for SQLite

    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 […]

  • Python database – MySQL installation summary (48)

    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 […]

  • Navicat imports CSV data into MySQL

    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 […]

  • Correction of partial installation problems in MySql-8.0.16

    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 # […]

  • MySql imports CSV files or tab-split files

    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 […]

  • Mysql-8.0.16-winx64/Linux Modify Root User Password

    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 […]

  • HeidiSQL Tool Exports and Imports MySQL Data

    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 […]

  • MySQL multitable queries and concat, concat_ws, and group_concat

    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 […]