Docker introduction also uses
1,Check kernel version, must be 3.10 And above
uname -r
2,install docker
yum install docker
3,input y Confirm installation
4,start-up docker
[root@localhost ~]# systemctl start docker
[root@localhost ~]# docker -v
Docker version 1.12.6, build 3e8e77d/1.12.6
5,Boot up docker
[root@localhost ~]# systemctl enable docker
Create ...
Posted by davidtube on Thu, 02 Jan 2020 15:06:48 +0100
JOIN and UNION in SQL
Building tables
Create table tb and insert data:
CREATE TABLE `tb_clazz` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'class id',
`grade` varchar(64) DEFAULT NULL COMMENT 'Class name',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
INSERT INTO `tb_clazz` (`id`, `grade`) VALUES ...
Posted by gabrielkolbe on Thu, 02 Jan 2020 13:53:07 +0100
Mysql join table sql collation
Mysql join table sql collation
This paper sorts out some sql usage of mysql join table:
Mysql join table sql collation
TABLE statement
Linked table query
Linked list updating
Linked list deletion
view
TABLE statement
/*Table structure for table `departments` */
CREATE TABLE `departments` (
`department_id` int ...
Posted by V34 on Thu, 02 Jan 2020 00:17:12 +0100
Linux basic learning LNMP environment construction
LNMP environment building
LNMP dynamic website deployment architecture is a dynamic website system solution composed of Linux+Nginx+Mysql+PHP components, which is free, efficient, extensible and low resource consumption
LNMP dynamic website architecture
yum install -y apr* autoconf automake bison bzip2 bzip2* compat* ...
Posted by fris on Wed, 01 Jan 2020 18:38:35 +0100
Mybatis generator: a plug-in for mybatis to automatically generate entity code
To use the Mybatis plug-in in maven project to automatically produce entity classes and mapping files, the following steps are required:
1. Create generatorConfig.xml file
(1) create plug-in file
(2) configure the path of relevant production files and the configuration of relevant parameters
2. Configure pom.xml
(1) add re ...
Posted by cupboy on Wed, 01 Jan 2020 14:09:45 +0100
Batch modification of IPOS friendly terminal group
Due to the needs of the company, it is necessary to change the transfer mode of IPOS friendly terminal group and IPOS friendly terminal group
Because this operation is very troublesome and tedious, close-up this template, batch update and one click completion
excel table format
2 tables in total
At present, each store h ...
Posted by hiberphoptik on Wed, 01 Jan 2020 05:25:18 +0100
Unity direct database
Take time today to take a note, and also review the previous things to record the Unity connection database.
Before you start, add the DLL you want to reference:
If not, you can download it on your own.
Enter the text.
First of all, in order to connect easily, use XML configuration file for connection information:
&l ...
Posted by dale282 on Wed, 01 Jan 2020 02:42:02 +0100
mysqld key functions and execution flow of MySQL8.0.11 source code analysis
mysqld is the SQL daemons (that is, the MySQL server). To use the client program, it must run because the client accesses the database by connecting to the server.
//Linux entry function
int mysqld_main(int argc, char **argv){
...... //Initialize operation
//Cyclic connection
mysqld_socket_acceptor->connecti ...
Posted by dswain on Tue, 31 Dec 2019 22:00:41 +0100
About MySQL 5.7 enabling bin log master-slave replication
Master-slave replication: generally used for real-time backup.
The next steps are as follows: master master database configuration synchronization, slave database configuration synchronization, master lock table / backup, slave data recovery, slave synchronization enabled, master unlocking, and completion.
##################### mysql5.7 bin-lo ...
Posted by croix on Tue, 31 Dec 2019 18:38:36 +0100
Max allowed packet setting of Mysql
max_allowed_packet is a setting parameter in Mysql, which is used to set the size of the accepted package. According to different situations, the default value may be 1M or 4M. For example, in the case of 4M, the size of this value is: 4 * 1024 * 1024 = 4194304
phenomenon
When a prompt appears in the log, such as "Packag ...
Posted by gabrielkolbe on Mon, 30 Dec 2019 16:42:23 +0100