VMware version number: 12.0.0
CentOS version: 7.0
I. Modifying the yum Source
[root@localhost ~]# rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
[root@localhost ~]# rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
[root@localhost ~]# rpm -Uvh http://dev.mysql.com/get/mysql57-community-re ...
Posted on Mon, 31 Dec 2018 23:24:09 -0500 by play_
The source of this paper is: http://www.cnblogs.com/wy123/p/6815049.html
The latest in learning MySQL, pure novice, also know little about Linux, because it is the latest download version of MySQL (MySQL 5.7.18) binary package, CentOS 7.2 test installation, easy to toss about later.Probably the following steps, installation and deletion ...
Posted on Mon, 31 Dec 2018 22:27:09 -0500 by notsleepy
Mysql's group by, have, count
Usually it is used incorrectly. Here are some examples.
Aggregate functions count, avg, min, max, sum, etc.
Some basic sql statements: http://www.cnblogs.com/xinge1993/p/4769468.html
Commonly used sql http://www.cnblogs.com/sunada2005/p/3411873.html
Grouped according to the values ...
Posted on Mon, 31 Dec 2018 15:06:08 -0500 by mikevarela
Introduction to LNMP Architecture
lamp architecture, linux, mysql, apache, php;
P-hp exists as a module of apache. libphp5 or libphp7 is used to parse P hp. Apache provides services called httpd. when a user logs on to the website, Apache will request the P HP module to interact with the database.
lnmg architecture, linx, mysql, nginx, php ...
Posted on Sat, 29 Dec 2018 10:33:09 -0500 by neiltaylormade
What is the isolation of transactions?
isolation is important for data consistency. There are many introductions on the internet. Recommended reading:
MYSQL official website
22.214.171.124 Transaction Isolation Levels
20.7.2 Transaction Isolation Levels
Generally speaking, if you use READ_UNCOMMITTED, this is suitable for ...
Posted on Sat, 29 Dec 2018 09:03:07 -0500 by avalonindigo
Spring uses Jdbcdaosupport, C3P0, and properties
1. C3P0 is an open source JDBC connection pool, which implements data source and JNDI binding and supports JDBC 3 specification and JDBC 2 standard extension. At present, open source projects using it include Hibernate, Spring, etc. The emergence of c3p0 greatly improves the efficiency ...
Posted on Thu, 27 Dec 2018 15:45:06 -0500 by fireant
The question is whether the query uses left(right)join filters in mysql to distinguish the data queried on and where.
Maybe you can't see any problems just by looking at two keywords. So let's use actual examples to see if there is any difference.
For example, there are two table structures
Table structure 1
DROP TABLE IF EXIST ...
Posted on Thu, 27 Dec 2018 15:21:06 -0500 by sdm
# Set the default character set for mysql client
Setting Port 3306
port = 3306
# Set up the installation directory of mysql
# Set up the storage directory of mysql database dat ...
Posted on Tue, 25 Dec 2018 17:54:06 -0500 by keziah
Add Micro-Signal GO_HOME_2020 to Discuss Java
Linux Installation Software
The first step is to see if there is a JDk in the system.
Step 2 Install JDK
The third step is to configure environment variables
Step 4: Enabling the configuration of environmental variables
Step 5: Look at environment variables
Posted on Tue, 25 Dec 2018 01:30:06 -0500 by WolfRage
Anti-counterfeiting code: Wanzhang Hongdun three cups of wine, Qianqiu Daye a pot of tea.I. MemCache JanesessionMemCache is a free, open source, high performance, distributed memory object caching system for dynamic Web applications to reduce the load of the database. By caching data and objects in memory, it can reduce the number of times to r ...
Posted on Tue, 25 Dec 2018 00:06:07 -0500 by ltoso