SQL basic language collation 2

029 SQL basic query and data update – workbench: Software – query data: select //Query the name of fruit with a price of 10.2 yuan from the fruits table select f_name(,f_price Better look) from fruits where f_price=10.2; – query with in keyword: discrete value //Query s from the fruits table_ Records with IDS 101 an ...

Posted by spamyboy on Sat, 07 May 2022 23:01:58 +0300

centos u disk installation and LNMP

1. Preliminary preparation: Download centeos 7.5: https://mirrors.aliyun.com/centos-vault/7.5.1804/isos/x86_64/ Download floppy disk pass, the registration code is Baidu. download putty, winscp 2. Operation steps: u disk production: Open UltraISO tool File -> Open Select your ISO file. Startup item Select to write the hard disk image ...

Posted by AliceG on Sat, 07 May 2022 16:36:06 +0300

Permission Subsystem--Shiro Security Framework

Introduction to Shiro Security Framework Overview of Shiro Shiro is an open source security framework under apache ( http://shiro.apache.org/) It extracts the functions related to the security authentication of the software system, realizes the functions of user identity authentication, authority authorization, encryption, session management, e ...

Posted by battlesiege on Sat, 07 May 2022 05:13:50 +0300

Safely shut down MySQL

When closing mysql server, various problems may occur due to the closing method. The following steps can reduce the occurrence of problems.   1. Stop copying In some special environments, the slave node may try to start from the wrong position. In order to reduce this risk, stop io thread first, so as not to receive new event information. mysq ...

Posted by richcrack on Sat, 07 May 2022 01:14:22 +0300

[Long Java Road] mybatis-plus

mybatis-plus Getting Started build table CREATE TABLE USER ( id BIGINT(20) NOT NULL COMMENT 'primary key ID', NAME VARCHAR(30) NULL DEFAULT NULL COMMENT 'Name', age INT(11) NULL DEFAULT NULL COMMENT 'age', email VARCHAR(50) NULL DEFAULT NULL COMMENT 'Mail', PRIMARY KEY (id) ); INSERT INTO USER (id, NAME, age, email) VALU ...

Posted by loureiro on Fri, 06 May 2022 04:42:39 +0300

hydd's LInux notes Day61

Day61 Overview of MHA cluster MHA introduction Introduction to MHA MHA(Master high Availability) It is developed by DeNA company in Japan. It is an excellent solution to realize high availability of MySQL. The automatic failover operation of the database can be completed within 0 ~ 30 seconds. MHA can ensure the consistency of data to the ...

Posted by eva21 on Thu, 05 May 2022 22:26:27 +0300

About SSM integration, it's enough to read this one ~ (nanny level hand-in-hand tutorial)

SSM (Spring + spring MVC + MyBatis) framework set is integrated by spring and MyBatis (spring MVC is part of spring), which is often used as the framework of web projects with simple data source.          catalogue 1, Create a web project based on maven Management: 1.1 complete the project structure ...

Posted by xxreenaxx1 on Thu, 05 May 2022 12:34:15 +0300

"Ultra vires" caused by one SQL injection

Original text from SecIN community - Author: tkswifty Relevant background   in the actual business development, SQL interaction is often an indispensable item in the business system. Mybatis, Hibernate and SpringData JPA are provided in Java to meet the needs of database interaction. However, for various reasons, when dealing with the i ...

Posted by ajpasetti on Thu, 05 May 2022 11:03:17 +0300

Install mysql-5.7.28-linux-glibc2.0 in CentOS 7 12-x86_ 64.tar. gz

1 check whether mysql service is installed by default in the system. If so, uninstall it. 1) Check command rpm -qa|grep mysql 2) Uninstall command rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64 2 if it is CentOS 7, a mysql branch database mariadb will be installed by default. You must uninstall this database first 1) Search rpm -e --node ...

Posted by newbie5050 on Thu, 05 May 2022 10:21:04 +0300

The mysql GTID master-slave replication fails and the synchronization process is resumed without stopping

GTID realizes master-slave replication data synchronization GTID is a successfully executed global transaction ID generated based on the original mysql server. It consists of server ID and transaction ID. this global transaction ID is unique not only on the original server, but also on all mysql servers with master-slave relationship. Officiall ...

Posted by dharprog on Thu, 05 May 2022 06:29:39 +0300