Database: primary key

Database ☞ primary key This paper is mainly based on the corresponding learning of the database, and summarizes an important knowledge point in the database - primary key! Some other knowledge points, such as foreign key, relational database, etc., will be interspersed in the middle. preface ThUTF-8...

Posted by smokebusted on Thu, 13 May 2021 07:29:44 +0930

Principle analysis of seata distributed transaction

principle seata involves the interaction between the three roles. This paper combs the basic interaction process in AT mode through the flow chart to lay the foundation for our future analysis. Suppose there are three micro services, namely, services A, B, C, where the service A calls the serviUTF-8...

Posted by wenquxing on Fri, 14 May 2021 03:54:19 +0930

Monitoring service zabbix deployment

Monitoring service zabbix deployment zabbix introduction zabbix is an enterprise level open source solution based on WEB interface, which provides distributed system monitoring and network monitoring functions. zabbix can monitor various network parameters to ensure the safe operation of the sUTF-8...

Posted by elfeste on Fri, 14 May 2021 07:45:41 +0930

MySQL Learning Notes

MySQL Learning Notes SQL: Structure Quevy Language 1. Basic Knowledge DDL: Data Definition Language DML: Data Operating Language - Operating Records in Database Tables DQL: Data Query Language DCL: Data Control Language - Define access and security levels 1. Login Method mysql -uroot -p123456 -UTF-8...

Posted by psy on Sun, 16 May 2021 02:35:33 +0930

java a simple orm framework development

catalogue ORM effect benefit Development of a simple ORM framework development environment The general structure of the project is shown in the figure below Implementation details First, add a dependency package to pom.xml Create databases and tables Create an entity class Student Create a reflUTF-8...

Posted by viperdk on Sun, 16 May 2021 02:45:29 +0930

Single column split multi column query and combined display of Mysql written examination questions

Single column split multi column query and combined display of Mysql written examination questions The thing is this: one day in the development group to see peers chatting, a peer sent a mysql written test. I studied for several hours with a try mentality. Don't talk too much, go straight to tUTF-8...

Posted by comicrage on Sun, 16 May 2021 07:54:56 +0930

Storage engine of MySQL architecture performance

Official reference: https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/storage-engines.html https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/storage-engines.html Storage engine Features of MyISAM engine: Transaction not supported Table level locking Reading and writing block each other, writingUTF-8...

Posted by antonbrk on Tue, 18 May 2021 03:39:24 +0930

[Brush Java Foundation + sql once a day] 2021-5-18

Preface Yesterday, I took a written test for a company and felt that my basic knowledge was weak, so I plan to brush some java basic knowledge questions to improve my proficiency in basic knowledge.However, the efficiency of not reviewing or correcting my own errors is also very low, so I intenUTF-8...

Posted by smudge on Wed, 19 May 2021 01:50:04 +0930

MongoDB in windows system installation configuration details and basic operation

1. Types of databases type Relational: oracle, mysql, sqlite, sqlServer, etcNot Only SQL: MongoDB (document), Redis, Memcache (memory) Differences between relational and non relational database software Similarities: Are database software, used to store project data difference: Relationship typUTF-8...

Posted by xentia on Wed, 19 May 2021 04:14:16 +0930

Review Mysql

Review Mysql emp table +-------+--------+-----------+------+------------+---------+---------+--------+ | EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO | +-------+--------+-----------+------+------------+---------+---------+--------+ | 7369 | SMITH | CLERK | 7902 | 1980-12-17 | 800.UTF-8...

Posted by cshinteractive on Sat, 22 May 2021 03:24:05 +0930