[mysql] bitwise operator
1. Bitwise operator
Bitwise operators are operators that evaluate on binary numbers. The bit operator first converts the operand into a binary number, then performs a bit operation, and finally changes the calculation result from binary to decimal. MySQL supports the following bitwise operators:
1.1 bitwise and operators
The bitwise ...
Added by gszauer on Sat, 12 Feb 2022 02:07:02 +0200
mysql advanced part_ You can take notes for private chat
DCL & Function & Index
review
Multi table relation:
One to many:
Add multiple foreign key columns to a general table,The value is the primary key of a table
To ensure the validity and integrity of data,Generally, after the table is under construction,Adding foreign key constraints by modifying table relationships
alter table M ...
Added by darkknightgaury on Sat, 12 Feb 2022 01:35:57 +0200
Implementing TinyWebServer from scratch
Original author: https://zhuanlan.zhihu.com/p/364044293
From 0 to server development -- TinyWebServer
preface:
Project code for modification, complete annotation and addition of functions:
https://github.com/white0dew/WebServer
What is it—— C + + lightweight Web server under Linux helps beginners quickly practice network pr ...
Added by DavidP123 on Fri, 11 Feb 2022 23:37:11 +0200
Core content of MySQL execution plan
Core content of MySQL execution plan
As we all know, mysql performs query optimization when executing queries. To put it simply, when executing, first generate an execution plan based on cost and rule optimization, and then execute the query according to the execution plan. This article mainly introduces the meaning of each output item of EXPL ...
Added by _OwNeD.YoU_ on Fri, 11 Feb 2022 20:16:21 +0200
Java project: hospital management system (java+Springboot+ssm+mysql+maven)
Source code acquisition: download from "resources" on the blog home page!
1, Project brief
Function: the project is a hospital management system written with springboot+layui+shiro. The business of the system is relatively complex. There are 36 tables in the database.
The project is divided into outpatient management, inpatient m ...
Added by Seraskier on Fri, 11 Feb 2022 17:35:27 +0200
How Macos uses Visual Studio code to connect Mysql with Java
background
Beginner Java, read green hand The tutorial of connecting Java to Mysql is missing the process of configuring jar files. Only Windows environment and Linux environment can be downloaded For novices, I'm very confused, so record it If you have the same environment as me, I hope you can help
Use environment
Computer: Macbook A ...
Added by youngsei on Fri, 11 Feb 2022 15:41:47 +0200
MySQL 7: MySQL indexing practice
1, Prepare test environment
1.1. Create data table
/* Employee table */
CREATE TABLE `emp` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`job` varchar(9) NOT NULL DEFAULT '',
`hiredate` date NOT NULL, /* Entry date */
`sal_grade` int(8) NOT NULL,
`age` ...
Added by DirtySnipe on Fri, 11 Feb 2022 11:32:23 +0200
Dynamic web pages - reverse analysis + cases
Introduction: this chapter mainly explains the related technologies of dynamic web page crawling. The crawling of dynamic web pages mainly includes reverse analysis method and simulation method. Today, we will mainly introduce the reverse analysis method. Later, we will focus on the use of selenium Library in the simulation method.
Dynamic ...
Added by JonathanS on Fri, 11 Feb 2022 09:32:07 +0200
SSM framework integration ideas (personal view)
SSM framework integration ideas (personal view)
The ssm framework is frequently used in projects. In order to focus on the business code in the project, I sorted out the steps to be used by the ssm framework. The following figure is the result of the sorting. (the green box in the figure is the key point of the process, and the changes in each ...
Added by froggie81 on Fri, 11 Feb 2022 07:57:10 +0200
Package output results
catalogue
After the execution of SQL statements in MyBatis, the processing of results
1. resultType result type refers to the java object that the data is converted to after the sql statement is executed. The java type is arbitrary
2. Alias the resultType of the returned result
3. Save q ...
Added by paullb on Fri, 11 Feb 2022 07:45:04 +0200