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