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