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