[RabbitMQ series that can be understood by laymen] - RabbitMQ quick introduction (including rich examples)
preface
Congratulations to all the friends who read this article for successfully unlocking the quick start content of RabbitMQ series ๐ Through this article, you will quickly learn what middleware is? What is rabbit MQ? How does RabbitMQ work? Finally, Xiaoming will take you through an example to deepen your impression of RabbitMQ ...
Added by s_dhumal on Wed, 23 Feb 2022 02:51:16 +0200
MySQL database management
1, Common data types
Database โ > data table โ > row (record): information used to describe an object Column (field): an attribute used to describe an object
Common data types:effectintintegerfloatSingle precision floating point (4 bytes, 32 bits)doubleDouble precision floating point (8 bytes, 64 bits)charFixed leng ...
Added by jeger003 on Tue, 22 Feb 2022 17:19:45 +0200
MySQL advanced knowledge points
Advanced knowledge points of MySQL (II)
3, Index optimization
1. What is an index
MySQL's official definition of Index is: Index is a data structure that helps MySQL obtain data efficiently. We can get the essence of Index: Index is a data structure. It can be simply understood as: ordered fast search data structure In addition to data ...
Added by MikeUK on Tue, 22 Feb 2022 14:50:23 +0200
Fault analysis | case analysis of master-slave synchronization error after MySQL slave fault restart
Author: Fu XiangNow living in Zhuhai, he is mainly responsible for the maintenance of Oracle, MySQL, mongoDB and Redis.Source: original contribution*It is produced by aikesheng open source community. The original content cannot be used without authorization. For reprint, please contact Xiaobian and indicate the source.1. Environmental descripti ...
Added by crees on Tue, 22 Feb 2022 09:22:34 +0200
Mysql barrier free, easy to learn the addition, deletion, modification and query of Mysql, and get started quickly with CRUD
Mysql barrier free and easy learning (IV) addition, deletion, modification and query of Mysql, CRUD quick entry
Mysql barrier free learning series
Mysql barrier free and easy learning (I) installation and configuration under Linux Mysql barrier free and easy learning (II) database tool DataGrid download and indefinite trial Mysql barrier f ...
Added by scottbarry on Tue, 22 Feb 2022 05:06:10 +0200
phpMyAdmin common getshell methods
catalogue
preface
1, View phpMyAdmin version
2, phpmyadmin common getshell methods
1. Premise
2. Website physical path acquisition method
3. Get shell through into outfile
4. Write shell through log file
5. Write shell through slow query
6. Create database and table and write to webshell
summary
preface
phpMyAdmin is a MySQL databa ...
Added by cags on Mon, 21 Feb 2022 15:02:01 +0200
Easy to understand JDBC tutorial - absolutely suitable for zero Foundation
The database realizes data persistence, but we finally have to process data in the program. How can we access the database and read and write data in java code?This requires a set of database standards set by sun company, which is JDBC (Java Database Connectivity). But it is only a specification, not a specific implementation. Therefore, the da ...
Added by mark s on Mon, 21 Feb 2022 11:04:55 +0200
springboot+mybatis+mysql transaction rollback
1. Introduction
reference resources:
mysql essentially uses database rollback, and the table engine needs InnoDB
The versions used are as follows
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.or ...
Added by cdickson on Mon, 21 Feb 2022 11:01:31 +0200
Mysql log management
Mysql log management
1, MySQL log management
The default log storage location of MySQL is / usr/local/mysql/data
There are two ways to open logs: through configuration files or through commands The log opened through command modification is temporary and will be closed after the service is shut down or restarted
MySQL common log types and s ...
Added by MikeUK on Mon, 21 Feb 2022 10:16:57 +0200
03. MySQL multi table & foreign key & database design
1. Multi meter
1.1 multi table description
In actual development, a project usually needs many tables to complete. For example, the database of a mall project needs many tables: user table, classification table, commodity table, order table
1.2 disadvantages of single meter
1.2.1 data preparation
Create a database db3CREATE DATABASE db ...
Added by markszy on Mon, 21 Feb 2022 07:16:34 +0200