2018 swoole actual combat 5-asynchronous mysql

Following the last chapter 2018 swoole 4-asynchronous io reading and writing This presentation Asynchronous mysql of swoole Analog data Create a new book table in the local test database and write the simulation data CREATE TABLE `book` `id` int(11) NOT NULL AUTO_INCREMENT, `content` text,( `titlle` varchar(255) NOT NULL COM ...

Posted on Fri, 31 Jan 2020 00:22:51 -0800 by Rai_de

Stored procedure of SqlServer2012 instance

--1. Call the help system to find the system stored procedure or function to display the version number and current system time of SQL Server. (hint: in help, you can query the corresponding functions or stored procedures according to keywords to complete the task.) the code screenshot and running result screenshot are as follo ...

Posted on Fri, 31 Jan 2020 00:05:26 -0800 by Mundo

Spring Road (31) - use NamedParameterJdbcTemplate to complete database operation (JavaConfig configuration)

background In the previous article, we completed the instance of database add, delete, modify and query under the JdbcTemplate, in which the configuration of related bean s is realized through xml and annotation. JdbcTemplate transfers parameters according to the placeholder location. In this article, ...

Posted on Wed, 29 Jan 2020 01:07:13 -0800 by jh21236

MyBatis from recognition to environmental construction

MyBatis from recognition to environmental construction What is the original jdbc like? Briefly review the process of using JDBC: ① introduce relevant database driven Jar package; ② create a database connection class This class includes: database driven loading, database connection configuration, connection object acquisition, release and close ...

Posted on Wed, 29 Jan 2020 00:52:16 -0800 by somedude

Getting started with MySQL and common command line

This article creates a rough learning list, and moves the details to the major learning websites. Graphical tools Navicat (cracked version) SQLyog PhpMyadmin Workbench DBeaver ... Connect to database mysql -uroot -p view the database show datebases; ps: end of command line; can't be less. ...

Posted on Tue, 28 Jan 2020 06:11:46 -0800 by spikeon

Using Logstash to synchronize Mysql and ElasticSearch data

Preface This article is used to record an operation of synchronizing Mysql data to ElasticSearch in case of forgetting The concept of incremental synchronization Logstash has its own timing task. By default, it moves data from Mysql to ElasticSearch every minute. However, the amount of data in MySQL ...

Posted on Sun, 26 Jan 2020 00:31:09 -0800 by ekalath

Find nearby network point geohash algorithm and implementation (PHP version)

Gehash has the following characteristics: First, geohash uses a string to represent the longitude and latitude coordinates.In some cases, it is not possible to apply an index on both columns at the same time (for example, previous versions of MySQL 4, the data tier of Google App Engine, etc.). With geohash, you can simply apply an index on one ...

Posted on Sat, 25 Jan 2020 08:16:57 -0800 by brainstorm

go microservice framework kratos learning note seven (kratos ward load balancing balancer)

go microservice framework kratos learning note seven (kratos ward load balancing balancer) Article directory go microservice framework kratos learning note seven (kratos ward load balancing balancer) demo demo server demo client pool dao service p2c roundrobin grpc official load balancing workfl ...

Posted on Sun, 19 Jan 2020 05:03:57 -0800 by penguinboy

More elegant use of limit (the effect of limit on the performance of mysql data query)

More elegant use of limit (the effect of limit on the performance of mysql data query) This paper re typesetting based on zhangyachen Source: zhangyachen https://github.com/zhangyachen/zhangyachen.github.io/issues/117 I. Preface First of all, explain the MySQL version: mysql> select version() ...

Posted on Sun, 19 Jan 2020 01:44:13 -0800 by lynncrystal

[probably the best in the whole network] summary notes of MySQL advanced introduction

view Meaning: MySQL started from version 5.0.1. It is a virtual existing table. The data of rows and columns comes from the tables used in the query defining the view. It is generated dynamically when using the view. Only the sql logic is saved, and the query results are not saved. Application scenari ...

Posted on Sat, 18 Jan 2020 23:00:45 -0800 by monk.e.boy