Programmer Think

catalogue 1. Overview of stored procedures and functions 2. Create stored procedure 3. Call stored procedure 4. View stored procedures 5. Delete stored procedure 6. Grammar 6.1 variables 6.2 if condition judgment 6.3 transfer parameters 6.4 case structure 6.5 while loop 6.6 repeat structure 6.7 loop statement 6.8 leave state ...

preface: Previous article We have introduced the usage of some common data types, such as int, char, varchar, etc. Blob and text types have not been introduced in detail. Although these two types of data types are not commonly used, they are still used in some scenarios. This article will mainly introduce the related knowledge of blob and text ...

Personal home page: 💖 A Niu💖 Note: Most of the key knowledge in this article is in the code comments, you must look carefully! I suggest you follow me! Wishing you all full harvest! Here's the point! Here's the point!!💗💗💗 Pull out your computer and start typing, buddies! (To be in full spirits~) 1. ...

Distributed transaction series tutorial - Chapter 4 - XA solution to solve distributed transactions 1, XA solution Xa is a distributed transaction protocol proposed by Tuxedo. Xa is roughly divided into two parts: transaction manager (TM) and resource manager (RM). The resource manager (RM) is implemented by databases, such as Oracle and DB2. ...

Installing MySQL in virtual machine MySQL is a relational database. It was originally a Swedish company called MySQL AB, which was later acquired by Oracle DB: database, which stores organized and standardized data DBMS: database management system, abbreviated as database software, database product. Database is a container created and operat ...

catalogue 1, Read write separation configuration 2, Verify read / write separation 1. Write verification 2. Read verification 3, Force read Master Library 4, References 1, Read write separation configuration Note that the configuration is database / Table + read / write separation. ShardingSphere version 3 x,4.0. 1,4.1. 1,5.0. There ar ...

1, ThreadLocal [resolve shared variables] 1.ThreadLocal is called thread variable, which means that the variable filled in ThreadLocal belongs to the current thread. This variable is isolated from other threads, that is, this variable is unique to the current thread. ThreadLocal creates a copy of the variable in each thread, so each thread can ...

1. MybatisPlus As always, the most important official documents are out first! Official documents 1. Import dependency <!--mysql--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.17</version&gt ...

WEB vulnerability - query method and error reporting blind note preface During SQL injection, many injections will not be echoed. The reason for not echoing may be the problem of the query method of SQL statements (the returned results of insert, update and delete only prompt completion / incomplete). At this time, we need to use relevant err ...

Real time is the future. Recently, we shared real-time computing services at Tencent cloud computing Oceanus (Flink)~Project backgroundThis paper introduces how to build a real-time data warehouse by combining MySQL database, stream computing Oceanus (Flink), HBase and cloud data warehouse ClickHouse, read MySQL data through stream computing Oc ...