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