Research on MySQL coding
preface
It was in 2002, and MySQL 4.1 began to support UTF-8 coding RFC 2279 It is stipulated that the code uses 1 ~ 6 bytes to store a single character, and MySQL developers checked it in September of the same year Source code The UTF-8 encoding is changed from the maximum 6 bytes to 3 bytes, so there is the current UTF8MB3. As we all know, U ...
Posted on Tue, 07 Dec 2021 02:36:02 -0500 by misterguru
Go Mysql transfer of Mysql data real-time incremental synchronization tool
@Go MySQL transfer of data real-time incremental synchronization tool: https://blog.csdn.net/weixin_...Installation, configuration and Kibana foundation of Elasticsearch notes: https://blog.csdn.net/weixin_...Go MySQL transfer official Manual: https://www.kancloud.cn/wj596...Environment installation of GO notes: https://blog.csdn.net/weixin_... ...
Posted on Tue, 07 Dec 2021 00:34:38 -0500 by Ima2003
Using Amoeba to realize mysql read-write separation
Using amoeba to separate mysql reading and writing
1. What is amoeba?
Amoeba (amoeba) project focuses on the development of distributed database proxy. Located between Client and DB Server(s). Transparent to clients. It has load balancing, high availability, sql filtering, separation of reading and writing, routing related queries to the targ ...
Posted on Mon, 06 Dec 2021 22:39:12 -0500 by ironmonk3y
JDBC (Java database connection)
JDBC (Java database connectivity)
Is a Java API for executing SQL statements, which can provide unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language. JDBC provides a benchmark, according to which more advanced tools and interfaces can be built, so that database develo ...
Posted on Mon, 06 Dec 2021 16:44:34 -0500 by mnewhart
Wildlife protection system based on Spring MVC + Spring + MyBatis
Resource download: https://download.csdn.net/download/weixin_44893902/45603787
Exercise point design: fuzzy query, delete, add, modify
1, Language and environment
Implementation language: JAVA language.Environment requirements: MyEclipse/Eclipse + Tomcat + MySql.Use technology: Jsp+Servlet+JavaBean or spring MVC + Spring + mybatis.
2 ...
Posted on Sun, 05 Dec 2021 17:52:36 -0500 by bigdaddysheikh
Database version management: flyway
flyway is a database migration tool that supports automatic backup and execution of SQL scripts. It is very convenient for us to deploy applications to multiple environments to initialize databases or upgrade database tables.
1, Why use flyway
Let's make an analogy with the Git version control tool, which is often used now. It can well ...
Posted on Sun, 05 Dec 2021 16:53:47 -0500 by ivi
MySQL advanced orderby optimization
Environmental preparation
CREATE TABLE `emp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`age` int(3) NOT NULL,
`salary` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
insert into `emp` (`id`, `name`, `age`, `salary`) values('1','Tom','25','2300');
insert into `emp` (`id` ...
Posted on Sun, 05 Dec 2021 06:51:36 -0500 by rtadams89
SQL advanced language
catalogue
alias
Subquery
exists
join query
view
combine
case
Date time function
Null and no values
regexp regular expression
stored procedure
deadlock
Common error codes
alias
...
Posted on Sun, 05 Dec 2021 03:57:56 -0500 by pozer69
Detailed explanation of MySQL join multi table connection knowledge
1. Introduction to SQL join multi table connection
SQL Join clause is mainly used in select statements to combine the rows of two or more tables, query based on the common field (often id field) between these tables, and return all rows that meet the conditions from multiple tables.
2. Common join clause types
Common join clause types include I ...
Posted on Fri, 03 Dec 2021 14:30:07 -0500 by Gaoshan
Introduction and use of MyBatis framework (the children next door will talk about it) -- Basic
1: Overview
MyBatis is an excellent persistence layer framework that supports common SQL queries, stored procedures and advanced mapping. MyBatis eliminates almost all the manual setting of JDBC code and parameters and the retrieval of result sets. MyBatis uses simple XML or annotations for con ...
Posted on Fri, 03 Dec 2021 10:11:03 -0500 by gasxtreme