Centos installs docker and uses docker to install mysql and redis
1, Install Docker Official installation documentation: https://docs.docker.com/engine/install/centos/ Refer to the official documentation for a simplified installation process: Step 1: uninstall (ensure that docker is not included in the system) sudo yum remove docker \ docker-client \ docker-cUTF-8...
Posted by raytri on Tue, 12 Oct 2021 12:15:15 +0530
EMQ X login authentication using MySQL
Introduction to EMQ X client login authentication Identity authentication is an important part of most applications. MQTT protocol supports user name and password authentication. Enabling identity authentication can effectively prevent illegal client connections. Authentication in EMQ X means UTF-8...
Posted by capb on Wed, 13 Oct 2021 03:25:30 +0530
windows environment uses InnoSetup to package and deploy spring cloud microservice project (JDK + MySQL + redis + Mini + Nacos + nginx)
preface The springcloud microservice project requires many components. It is quite convenient for us to deploy using docker in the Linux environment. However, in view of the fact that docker is not very friendly to the windows environment, the traditional deployment method needs to install manUTF-8...
Posted by skot on Thu, 14 Oct 2021 11:43:17 +0530
MySQL - transaction details
1, Transaction definition Transaction Transaction: a smallest non separable unit of work; Usually, a transaction corresponds to a complete business (for example, bank account transfer business, which is the smallest work unit) A complete business requires batch DML(insert, update, delete) stateUTF-8...
Posted by Fed51 on Fri, 15 Oct 2021 05:47:02 +0530
Java link database, detailed explanation of JDBC use (mysql)
JDBC 1. What is JDBC? Java DataBase Connectivity(Java Language connection database) 2. What is the essence of JDBC? JDBC yes SUN A set of interfaces formulated by the company( interface) java.sql.*; (There are many interfaces under this software package.) Interfaces have callers and implementerUTF-8...
Posted by Wave on Fri, 15 Oct 2021 23:03:27 +0530
MySQL -- multi table query
1) Inner join query – inner join Syntax 1: select f1,f2,f3... from table1 inner join table2 on Association matching criteria Grammar 2: select f1,f2,f3... from table1,table2,table3 where Association matching criteria (1) Self connection Concept: it is a special equivalent connection in internalUTF-8...
Posted by fugix on Sat, 16 Oct 2021 03:33:28 +0530
MySQL Basics (self taught)
##Objectives of this unit 1, Why learn database 2, Related concepts of database DBMS,DB,SQL 3, Characteristics of database storage data 4, Initial MySQL Introduction to MySQL products MySQL product installation ★ Start and stop of MySQL service ★ Login and logout of MySQL service ★ Common commaUTF-8...
Posted by duk on Sat, 16 Oct 2021 10:17:00 +0530
Some supplements to mysql database
Database concept A database is where data is stored. In the computer, in the memory and in the hard disk, everything is stored in the database. The place where these data are stored is called the database. It can also be called electronic "filing cabinet". The database in computer science and UTF-8...
Posted by jmgarde on Sat, 16 Oct 2021 10:54:07 +0530
Teach you MySQL stored procedures from zero. Don't worry about being asked in the interview
💗 MySQL stored procedure 🌹 0. Environmental description Softwareeditionmysql5.6HeidiSQL 🎄 1. Instructions Stored procedure is an important object of the database. It can encapsulate the set of SQL statements, can be used to complete some complex business logic, and can input and output paraUTF-8...
Posted by pete07920 on Mon, 18 Oct 2021 04:34:59 +0530
Egg: upload excel file and analyze the content, save it to mysql database and save it locally. vue+egg realizes the front and back ends
preface: There are two methods to upload in egg: Official entrance File mode: Stream mode: catalog: Effect achieved: 1. On the interface 2. In the code: after uploading, data will be added to mysql, and the uploaded files will be saved in public/ upload/ excel Here is the usage of his File modeUTF-8...
Posted by fizix on Tue, 19 Oct 2021 04:23:52 +0530