Fuzzy/Multiline/Grouping/Sorting/Paging Queries for MySQL Database Tables and Explanation of the Word MySQL Data Type--Explanation 2

Foreword: Today I will tell you: MySQL database table fuzzy/multiline/grouping/sorting/paging query and MySQL data type explanation, of course, if you are interested in the basic operation of the database--database creation/table addition/deletion check, you can see my article-- Basic operations for MySQL database tables (add, delete, change ch ...

Posted by jabbaonthedais on Sat, 21 Mar 2020 23:19:49 -0700

C ා operate mysql database

This paper introduces the operation of adding, deleting, modifying and querying mysql database. 1. Install the database, pay attention to the installation of Connector NET. 2. Introduce MySql.Data.dll and add project reference. The general location of the file is: C:\Program Files (x86)\MySQL\Connector NET xx\Assemblies\v xx (determined by MySQ ...

Posted by Reviresco on Fri, 20 Mar 2020 12:15:56 -0700

Linux centos install mysql

Installation steps #decompression tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz #Copy the extracted mysql directory cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql #Add user group groupadd mysql #Add user mysql to user group mysql useradd -g mysql mysql #install cd /usr/local/mysql/ mkdir ./data/mysql chown -R ...

Posted by shock on Fri, 20 Mar 2020 11:21:03 -0700

Elasticsearch add, delete, modify and query (2)

ES Restful API GET, POST, PUT, DELETE, HEAD meaning: 1) GET: gets the current state of the request object. 2) POST: changes the current state of the object. 3) PUT: create an object. 4) DELETE: destroy the object. 5) HEAD: request to get the basic information of the object. The new document in ES (under Index/type) i ...

Posted by Hell Toupee on Fri, 20 Mar 2020 09:05:37 -0700

Download Zabbix Graph chart through PowerShell

Generally, the chart of Zabbix Graph page is mostly used to write reports, forming a more intuitive report.However, if there are a large number of charts to view, it will lead to screenshots for each item of each host, which is inefficient. This time, I specially wrote a script to complete this work. In order to understand, I set up a zabbix t ...

Posted by Karlos2394 on Fri, 20 Mar 2020 02:24:48 -0700

Practical guide to anti deletion library

Some very good enterprise level functions of the database are "military for a thousand days, military for a while". For example, the Recycle Bin function in Oracle 10g can play the role of special soldiers in special circumstances. For example, when you delete a table space or a user schema, you may delete many tables, including some ...

Posted by ksteuber on Fri, 20 Mar 2020 01:24:48 -0700

MySQL slow query - enable slow query

I. Introduction Opening the slow query log enables MySQL to record the statements that are queried for more than the specified time. Only by locating and analyzing the bottleneck of performance, can we better optimize the performance of the database system. 2, Parameter description Slow query log slow query on status Slow q ...

Posted by aesthetics1 on Thu, 19 Mar 2020 11:14:18 -0700

Using mysql module of python

PyMySQL installation Before using PyMySQL, we need to make sure PyMySQL is installed. PyMySQL download address: https://github.com/PyMySQL/PyMySQL. If it is not already installed, we can use the following command to install the latest version of PyMySQL: $ pip install PyMySQL If your system does not support the pip command ...

Posted by ganlal on Thu, 19 Mar 2020 09:10:11 -0700

mysql cache settings

Some sql runtime is time-consuming, consumes system resources, and cannot be further optimized, and each time the data is obtained, it does not change much. Then the information obtained by this sql statement will be cached for the next execution This saves system resources very much View query cache size mysql> selec ...

Posted by centered effect on Wed, 18 Mar 2020 09:19:40 -0700

MySQL -- basic database operation (2)

– preparation before database operation – create database – create database python_test_1 charset=utf8; – using databases – use python_test_1; – students table – create table students( – id int unsigned primary key auto_increment not null, – name varchar(20) default ", – age tinyint ...

Posted by ksteuber on Wed, 18 Mar 2020 09:11:11 -0700