MySQL master-slave replication and read-write separation

1, The theoretical part of MySQL master-slave replication 1. Overview of master-slave replication and read-write separation In the substantive production environment, the reading and writing of the database are in the same database server, which can not meet the needs of the real hospital. WheUTF-8...

Posted by ganesh on Fri, 24 Sep 2021 13:12:24 +0530

In September, datawhale formed a team to learn task06 SQL autumn trick

In September, datawhale formed a team to learn task 06 autumn recruit questions I was too busy, so I chose some topics to do, Woo woo Autumn move script A Supplementary learning: CREATE DATABASE in DataGrid, etc As shown in the figure next step It seems that database is similar to schema in MySUTF-8...

Posted by rajns on Sat, 25 Sep 2021 23:31:32 +0530

From getting started to mastering the use of Mybatis framework -- configuration analysis of Mybatis

Official documentation for Mybatis3 configuration(Configuration) properties(Properties) settings(Settings) typeAliases(Type alias) typeHandlers(Type (processor) objectFactory(Object factory) plugins(Plug in) environments(Environment configuration) environment(Environment variables) transactionUTF-8...

Posted by NoMansLand on Sat, 25 Sep 2021 23:49:33 +0530

Deployment and implementation of MySQL

Deployment and implementation of MySQL 1, MySQL version selection For versions after MySQL 5.6, the official version is recommended.Percon a: after version 5.6, MySQL integrates Percona optimization into the official version.MariaDB: version 10.3 is very different from the official MySQL InnoDUTF-8...

Posted by KFC on Sun, 26 Sep 2021 14:14:52 +0530

Data table operation

1, Create table create table Table name( Field name type constraint, Field name type constraint ... ) #example create table students( id int unsigned primary key auto_increment, name varchar(20), age int unsigned, height decimal(5,2) ) 2, Delete table #Format 1. It is not judged whether the taUTF-8...

Posted by marketboy on Mon, 27 Sep 2021 01:12:50 +0530

Database learning notes

MySQL database matters needing attention 1.where query=No, No== 2.MySQL The string subscript starts with 1, LIMIT Qualified query with subscript starting from 0 3,Teaching video sql Documents, salary yes varchar Type, so+0´╝îexpress int type 4.image subject For this keyword, use``,`subject`,thatUTF-8...

Posted by tartou2 on Mon, 27 Sep 2021 09:30:20 +0530

Mybatis05 - one to many and many to one processing

10. Many to one processing Many to one understanding: -Multiple students correspond to one teacher -For students, it is a many to one phenomenon, that is, a teacher is associated with students! Database design CREATE TABLE `teacher` ( `id` INT(10) NOT NULL, `name` VARCHAR(30) DEFAULT NULL, PRIMUTF-8...

Posted by kaoskorruption on Mon, 27 Sep 2021 10:27:47 +0530

The most detailed SpringBoot learning in the whole network - day06

Introduction to spring data For the data access layer, whether SQL (relational database) or NoSQL (non relational database), the bottom layer of Spring Boot adopts the way of Spring Data for unified processing.The bottom layer of Spring Boot uses Spring Data to uniformly process various databasUTF-8...

Posted by Leppy on Mon, 27 Sep 2021 17:28:56 +0530

[2021 Jiangxi Sai University Group]wp

easyphp Front End Code Leakage foreach ($_POST as $item => $value){ $$item=$$value; $secret = $$item; } foreach ($_GET as $key => $value){ if ($key=='flag'){ $str=$value; $$str=$secret; } } if (isset($hehe)){ echo "".$hehe.""; } //flag+flaag=DASCTF{XXXXXXX} Simple variable overUTF-8...

Posted by sspatel82 on Mon, 27 Sep 2021 23:00:54 +0530

Detailed steps and workflow of lamp architecture in PHP version 7.4.24

1. Preface A lamp architecture was built a few days ago, which is not detailed, so we built another one 2.lamp introduction LAMP is Linux + Apache +Mysql/MariaDB + Php/Perl/Python It is an open source software for a group of dynamic websites or servers. Except Linux, other components are theirUTF-8...

Posted by spetstnelis on Tue, 28 Sep 2021 14:38:37 +0530