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