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
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
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
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.
Posted by richcrack on Sat, 07 May 2022 01:14:22 +0300
Overview of MHA cluster
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
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.
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
Original text from SecIN community - Author: tkswifty
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
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
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