MySQL -- add, delete, modify and query (basic)
This part is mainly aimed at the basic operation, but also a skilled application of learning knowledge.
I. concept of database
First, what is a database? What does the database do? If only to store data, we can use file storage. Why get a database? To answer this question, first of all, we need to know the insecurity of storing data with ...
Added by f8ball on Sun, 05 Dec 2021 19:45:16 +0200
MySQL master-slave replication, separation and resolution
catalogue
1, MySQL master-slave replication
1.1 master slave replication architecture and principle
1.1.1 service performance expansion mode
1.2 MySQL extension
1.2.1 what is read-write separation?
1.2.2 why is read-write separation necessary
1.2.3 when should I separate reading from writing
1.2.4 master slave copy and read / write sepa ...
Added by Isoss on Sun, 05 Dec 2021 19:04:14 +0200
Nacos introduction, download and configuration persistence to Mysql
scene
What is Nacos
Nacos is dedicated to helping you discover, configure, and manage microservices. Nacos provides a set of easy-to-use feature sets to help you quickly realize dynamic service delivery Service configuration, service metadata and flow management. Nacos helps you build, deliver, and manage microservice platforms mor ...
Added by scnov on Sun, 05 Dec 2021 12:59:45 +0200
Basic use of mybatis
1, hello world
1. Environmental construction create maven web project mybatis01 and add maven dependencies as follows.
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId> ...
Added by Irvin Amoraal on Sun, 05 Dec 2021 06:54:56 +0200
MySQL variables, process control and cursors
catalogue
1. Variable
1.1 system variables
1.1.1 classification of system variables
1.1.2. View system variables
1.2 user scalar
1.2.1 classification of user variables
1.2.2 session user variables
1.2.3 local variables
1.2.4 comparing session user variables with local variables
2. Define conditions and handlers
...
Added by thepriest on Sun, 05 Dec 2021 05:47:54 +0200
MySQL notes 4 - table creation, addition, deletion and modification
9 establishment, addition, deletion and modification of table
9.1 table creation (table creation)
Syntax format of table creation: (table creation belongs to DDL statement, and DDL includes: create drop alter)
create table Table name(Field name 1 data type, Field name 2 data type, Field name 3 data type);
create table Table name(
Field na ...
Added by sheen.andola on Sun, 05 Dec 2021 02:28:25 +0200
How to solve the problem that getting timestamp from Mysql database is 8 hours earlier than the normal time
This article introduces the relevant knowledge of "how to solve the problem of obtaining timestamp from Mysql database 8 hours earlier than the normal time". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can rea ...
Added by eddy666 on Sat, 04 Dec 2021 21:50:02 +0200
Use of MyBatis framework
1, Overview
1. Framework
The skeleton of framework project development encapsulates many details, so that developers can use simple interface calls to realize functions and improve development efficiency.
Problems to be solved by the framework
The most important thing of the framework is to solve the problem of technology integration. It sh ...
Added by Ryokotsusai on Sat, 04 Dec 2021 07:22:10 +0200
05 SQL statement execution process analysis
sql execution statement flow analysis
The whole processing flow is in exec_simple_query function. The code structure is as follows:
/*
* exec_simple_query
*
* Execute a "simple Query" protocol message.
*/
static void
exec_simple_query(const char *query_string)
{
...
//Original syntax tree acquisition
/*
* Do basic parsing of the quer ...
Added by teege84 on Sat, 04 Dec 2021 05:08:34 +0200
The lottery management system is realized through Mysql+Swing+jsp
catalogue
Function Preview
Back end main content
Login panel
Management panel
Data panel
Menu bar
Panel switching
Operation database
Main form
key technology
verification
Operating system process
Beautify form
Front end part
Registration interface
jsp realizes front-end and back-end interaction
Fu ...
Added by adityamenon90 on Sat, 04 Dec 2021 01:58:50 +0200