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
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
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
#Add user mysql to user group mysql
useradd -g mysql mysql
chown -R ...
Posted by shock on Fri, 20 Mar 2020 11:21:03 -0700
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
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
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
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
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
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
– 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