Union index (leftmost prefix principle)

1) What is a federated index? A federated index refers to indexing multiple columns in a table. In other words, multiple columns on the table add up to form an index for fast query. 2) How do I use federated indexes? First, add an index to the table Add to table when creating table: CREATE TABLE t( a int, b int, primary key(a), ...

Posted by Bit343 on Fri, 15 Oct 2021 14:42:37 -0700

1500 lines of code! Have their own chat room ---- socket chat room implementation (GUI, thread, TCP)

Java learning punch in: on the 31st and 2nd day [complete the socket chat room construction project] Java cultivation program (punch in day 31 and day 2) Content management: implementation of Sockect chat room The Java interface uses various components. Don't worry about what you don't know about this part. It's OK to master one at p ...

Posted by van__ on Fri, 15 Oct 2021 11:19:41 -0700

36-Blog Site Database-Blog Comment Information Data Operation

36-Blog Site Database-Blog Comment Information Data Operation Item Description Nowadays, micro-blog and blog publishing information have become the main information publishing and dissemination system. How to manage these data, this project mainly operates on the blog information table and commentary table in the blog website. Blog site data ...

Posted by Weedpacket on Fri, 15 Oct 2021 09:19:53 -0700

Python 3 implementation and improvement of Apriori algorithm

Python 3 implementation and improvement of Apriori algorithm Code reference machine learning practice The improved methods are partly from data mining: concepts and technologies, and partly from https://blog.csdn.net/weixin_30702887/article/details/98992919 I summarize and implement here, and record my learning of Apriori algorithm First ...

Posted by narch31 on Wed, 13 Oct 2021 21:22:17 -0700

mysql advanced learning notes

Indexes Data structure to help mysql obtain data efficiently Disadvantages: it reduces the efficiency of updating tables and increases disk overhead. B tree and B + tree The number of B's in the m-fork contains at most m-1 keys per node, while the number of B's + contains at most M keys The leaf node of the B + tree stores all key informati ...

Posted by pheagey on Wed, 13 Oct 2021 14:20:22 -0700

Xiao Meng 5w received a small blind box program, which was developed in three weeks!

Today's young people can really play, more and more new things come out, and more and more fun things are popular. It's like the blind box of the recent fire stall. Seriously, I didn't know what a blind box was before. In front of me, a fan asked me to develop a small blind box program. Therefore, I went to the stall and bought some bl ...

Posted by moose4204l on Wed, 13 Oct 2021 13:49:23 -0700

[understand MySQL's DQL language] - sort and group query

preface This blog follows the content of the previous blog and supplements the DQL language. It mainly talks about the sorting query, common functions and grouping query in the DQL language. These three pieces of content mainly reflect the sorting and grouping query functions of MySQL. Here is the link to the blog that knows MySQL for the ...

Posted by Buglish on Wed, 13 Oct 2021 13:38:59 -0700

Java Concurrent Programming

Note source: Dark horse programmers have a comprehensive and in-depth study of Java Concurrent Programming and a full set of tutorials of JUC concurrent programming Note source: AC_Jobim JUC concurrent programming tutorial Some personal opinions are attached. If there are mistakes, please correct them! 1, ThreadLocal details Good b ...

Posted by phpvn.org on Wed, 13 Oct 2021 12:56:32 -0700

Redis -- distributed cache

What is distributed caching? In the original application, the cache is usually stored in the JVM of the local application. However, with the trend of project microservicing, after the project is reconstructed in the way of microservice, the cache should be managed and stored by a separate server and deployed in different physical areas to achi ...

Posted by Blockis on Wed, 13 Oct 2021 12:11:08 -0700

Introduction to applet (Vue like rendering and database)

Vue like rendering and database of wechat applet Front row idea: the content of this article includes: Class Vue rendering → wxss.js.wxml → cloud development → cloud development usage (storage and database) → database initialization → insert → json file import → query → life cycle Front row tips: Th ...

Posted by prasadharischandra on Wed, 13 Oct 2021 09:36:09 -0700