MySQL 8.0 new features, index can be hidden!

Author: fabricated belief Original text: https://segmentfault.com/a/1190000013803247 This paper introduces several main new features of 8.0 in relational database. You may already know that MySQL has provided NoSQL storage function since version 5.7, and some improvements have been made in 8.0. However, since this function is rarely used in p ...

Posted by php.ajax.coder on Fri, 04 Mar 2022 00:21:33 +0100

Rectangular split (two point answer)

subject There is a large rectangle on the plane, with the coordinates of the lower left corner (0,0) and the upper right corner (R,R). The large rectangle contains some small rectangles, which are parallel to the coordinate axis and do not overlap each other. The vertices of all rectangles are integral points. It is required to draw a strai ...

Posted by eyalrosen on Thu, 03 Mar 2022 20:42:42 +0100

Tear Front End JavaScript by Hand (Phase 1)

1. Anti-shake function (debounce) Purpose: Prevent users from triggering events multiple times and wasting multiple requests Principle: Callback is executed after an event triggers for n seconds; If triggered again within n seconds, the time is recounted; const debounce = function(func,delay = 50){ /* func: Functions requiring ...

Posted by JayBlake on Thu, 03 Mar 2022 19:10:25 +0100

Understand object Defineproperty and Proxy, vue3 Why does 0 use Proxy?

preface During the interview a few days ago, the interviewer asked this question and felt that he didn't answer it very well. I'll sort it out here~ The length of the article will be relatively long, but after reading it, you will gain a lot ~ I hope you keep reading it~ Object.defineProperty() Function: define a new property on an object, o ...

Posted by norbie on Thu, 03 Mar 2022 05:27:36 +0100

Front end interview handwritten output questions

preface: The output of the code is a common topic in the interview. A piece of code may involve a lot of knowledge points, which examines the applicant's basic ability. In the front-end interview, the common code output problems mainly involve the following knowledge points: asynchronous programming, event loop, this pointing, scope, variable ...

Posted by MaxD on Wed, 02 Mar 2022 17:12:06 +0100

[thread status, wait and wake-up, Lambda expression, Stream flow]

day09 [thread status, wait and wake-up, Lambda expression, Stream flow] Today's content Multithreading Thread status -------- -- > must be masteredWaiting for wake-up mechanism -------- must be mastered Lambda expression Usage scenarios of Lambda expressions -------- -- > it is recommended to masterFormat of Lambda expression (sta ...

Posted by boske on Wed, 02 Mar 2022 01:29:30 +0100

Differences between in and not in, exists and not exists in SQL and performance analysis

1. in and exists In is a hash connection between the outer table and the inner table, while exists is a loop loop loop for the outer table. Each loop loop loop queries the inner table. It has always been inaccurate to say that exists is more efficient than in. If the two tables of the query are of the same size, there is little difference b ...

Posted by The Little Guy on Mon, 28 Feb 2022 01:45:33 +0100

10 great JavaScript shorthand skills

Today I want to share 10 great JavaScript shorthand methods, which can speed up the development speed and get twice the result with half the effort. Let's go! 1. Merge arrays Common writing: We usually use the concat() method in Array to combine two arrays. Using the concat() method to merge two or more arrays does not change the existing A ...

Posted by jadebabe on Sat, 26 Feb 2022 12:07:33 +0100

Interview: this keyword

preface this topic is an unavoidable difficulty in study, work and interview. Let's start with a topic: var name = "Xiao Hong"; function a() { var name = "Xiaobai"; console.log(this.name); } function d(i) { return i(); } var b = { name: "Xiao Huang", detail: function() { console.log(this.name); }, show: fu ...

Posted by cyanblue on Sat, 26 Feb 2022 09:14:49 +0100

Filter (super detailed)

Statement: This article is the notes sorted out according to the blogger's learning content. It is only used for exchange learning. If you need to watch the video, please move to: http://www.atguigu.com/ 1.Filter ? What is a filter Filter filter is one of the three major components of Java Web. The three components are: Servlet program, List ...

Posted by reddevil on Sat, 26 Feb 2022 07:10:57 +0100