Elastsearch basic query (open)
Elastsearch basic query
Elasticsearch is a very powerful full-text search engine. The purpose of using elasticsearch is to quickly query the desired data.
Basic query: query with elastic search built-in query criteria
Composite query: a composite query that combines multiple basic queries
Filter: when querying, filter out the desired data ...
Added by natronp on Mon, 04 May 2020 06:30:21 +0300
HAProxy https configuration, four-tier load balancing, and access control for load balancing services
In the previous section, we talked about the configuration of haproxy's access control ACL. For a review, please refer to https://www.cnblogs.com/qiuhom-1874/p/12817773.html ; Today let's talk about the configuration of haproxy's https, tcp-based four-tier load balancing, and access control.
First let's look at the configuration of haproxy's ht ...
Added by amandas on Sun, 03 May 2020 09:12:33 +0300
Three methods of mysql copying table data and table structure
1, Copy table structure
Method 1:
mysql> create table a like users; //Copy table structure
Query OK, 0 rows affected (0.50 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| a |
| users |
+----------------+
2 rows ...
Added by Dj_Lord on Sun, 03 May 2020 04:02:36 +0300
Spring boot (9): spring boot uses Druid data source
Druid is a database connection pool implementation on Alibaba open source platform. It combines the advantages of C3P0, DBCP, PROXOOL and other DB pools, and adds log monitoring. It can monitor the connection of DB pool and the execution of SQL. It can be said that Druid is a DB connectio ...
Added by hpg4815 on Sun, 03 May 2020 00:27:55 +0300
Java learning notes 51 (integrated project: home accounting system)
This case almost uses all the contents of the first 50 articles to realize a simple family accounting software
Function: add, delete, modify, query by criteria
Required jar package:
commons-dbcp-1.4.jar
commons-pool-1.5.6.jar
mysql-connector-java-5.1.37-bin.jar
commons-dbutils-1.6.jar
Database table creation:
/*
Create database
Name gjp
...
Added by yashvant on Sat, 02 May 2020 22:52:29 +0300
Simple operation of php and mysql
mysql is a fast, reliable and easy-to-use database system running on the server, which is often combined with php for web development.
There are two ways for php to connect to mysql:
mysql i ('i 'means improved): only for mysql
pdo (php data objects): can be used in many databases
mysqli connection mode can be divide ...
Added by hightechredneck on Sat, 02 May 2020 00:52:55 +0300
Get database metadata
MySQL provides a variety of methods to obtain database metadata (information about the database and various objects in it):
*Various SHOW statements, such as SHOW DATABASES or SHOW TABLES;
*Information? Table in schema database;
*Command line programs, such as mysqlshow or mysqldump.
Use SHOW statement to get metadata
-- List accessible ...
Added by riyaz123 on Thu, 30 Apr 2020 21:47:29 +0300
gorm series - Update
Catalog
Gorm update operation
Update all fields
Update modified fields
Update selected fields
No Hooks updates
Batch update
Update with SQL expression
Modify values in Hooks
Other update options
Gorm update operation
Update all fields
Save() updates all fields of the object by default, even if you don't have an assignment.
package main
im ...
Added by deft on Mon, 27 Apr 2020 18:54:52 +0300
CentOS7 Installation\Uninstall MySQL
1. Download and install MySQL's official Yum Repository
[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
Install MySQL Server
root@localhost ~]# yum -y install mysql-community-server
2. MySQL database settings
Start MySQL
[root@localhost ~]# systemctl start mysqld.service
View MySQL r ...
Added by tweet on Sun, 26 Apr 2020 19:48:31 +0300
Java project creation -- unified result processing and exception handling
1, IDEA plug-in use
1. Description
Spring boot 2.2.6, JDK 1.8 and mysql 8.0.18 are used as demonstration here.
Use IDEA as a development tool.
2. IDEA plug-in -- Lombok
(1) IntroductionLombok can automatically generate constructor, getter/setter, equals, hashcode, toString and other methods for properties during compilation through annotation ...
Added by juneym on Sun, 26 Apr 2020 14:45:44 +0300