SQL notes (compact version)
Database structure diagram
1. Retrieve data
1.1 select database
USE sql5th;
1.2 select a single column
select prod_name from Products;
+---------------------+
| prod_name |
+---------------------+
| Fish bean bag toy |
| Bird bean bag toy |
| Rabbit bean bag toy |
| 8 inch teddy bear |
| 12 inch teddy bear |
| ...
Added by sc00tz on Sun, 20 Feb 2022 09:13:52 +0200
Memory management in C + + Basics
C/C + + memory distribution
Program memory in C/C + + can be divided into kernel space, stack, memory mapping segment, heap, data segment and code segment. Among them, we mainly need to understand:
regionfunctionMemory release formStackStore non static local variables, function parameters and return valuesautomaticheapProgram dynamic memo ...
Added by hypertech on Sun, 20 Feb 2022 09:13:01 +0200
Basic data structure: linked list, monotone stack, monotone queue
1, Linked list and adjacency list
1 linked list
here, we do not use the commonly used structure plus pointer to realize the linked list, because in this way, each node should be new. The number of linked list nodes in common written test questions is 1e5~1e6 level, and new alone is enough to timeout.
so we use arrays ...
Added by ddragas on Sun, 20 Feb 2022 09:08:23 +0200
05 Gateway application practice
Gateway introduction
Background analysis
We know that a large-scale system is often divided into many micro services when it is designed. So how can a client call so many microservices? The client can directly send a request to the microservice. Each microservice has a public URL that can be directly mapped to a specific microservice. If ther ...
Added by BTalon on Sun, 20 Feb 2022 09:07:52 +0200
Cloning and importing DOM nodes
prefaceWhen using JS to operate DOM nodes, we often use the operation of cloning (or importing) nodes. What methods can achieve the effect of node cloning (or importing)?Today, let's summarize the methods that can achieve the effect of node cloning (or import).node.cloneNode()When it comes to cloning nodes, the first thing we can think of must ...
Added by Danaldinho on Sun, 20 Feb 2022 09:06:06 +0200
HashMap source code analysis + interview questions, based on jdk1 8 line by line analysis, this is enough for the interview!
Before reading this article, it is recommended to read the blogger's article on red black tree, which describes the evolution from binary sort tree → AVL tree → red black tree. Transmission address: Quick understanding of red and black trees
HashMap source code analysis + interview questions
1, Hash introduction
Core theory
...
Added by lingo5 on Sun, 20 Feb 2022 08:43:57 +0200
After the jvm heap memory overflows, can other threads continue to work
Reprinted from: Original link
Author: https://gosaintmrc.github.io/
Recently, a meituan interview question appeared on the Internet: "after one thread is OOM, can other threads still run?".
I think there are many unreliable answers on the Internet.
This question is actually very difficult. The knowledge points involved include ...
Added by ForumSecure on Sun, 20 Feb 2022 08:37:52 +0200
Linux learning - wildcards and special symbols
1. Wildcard
1.1 effect on documents
*: matches any 0 or more characters or strings, including empty strings
[root@VM-0-17-centos ~]# rm -f *.sh
?: Match any 1 character
[root@VM-0-17-centos ~]# ls ?.*
a.out
[root@VM-0-17-centos ~]# ls ????.* # Can be used multiple times
info.txt test.sh
1.2 action on file / character
[abc ...
Added by SteveMellor on Sun, 20 Feb 2022 08:34:20 +0200
Log management in LINUX system
Experimental environment
systemctl stop firewalld
1.journald
Service Name: SYSTEMd journal service journalctl Default log storage path: / run/log
Experiment 1 usage of journalctl command
journalctl -n 3 ## latest 3 entries in log --since "2020-05-01 11:00:00" ## displays the log after 11:00 --until "2020-05-01 11:05:00" ...
Added by PrinceOfDragons on Sun, 20 Feb 2022 08:23:00 +0200
Go Quiz: precautions for function naming and return value from the go interview question (more than 80% of people answered wrong)
subjectChief engineer of Redhat and Maintainer of Prometheus open source project Bartłomiej Płotka A Go programming question was asked on Twitter, and more than 80% of the people answered it wrong.The title is as follows. Answer the output of the following program.// named_return.go
package main
import "fmt"
func aaa() (done func(), err error ...
Added by wmac on Sun, 20 Feb 2022 08:21:42 +0200