Build Nginx+Tomcat+MYSQLDocker Container Actual

Before Docker can run a container, it needs to use mirroring as the base environment. Mirroring is the key to the creation of the entire Docker container. The most flexible method to create a mirror is based on the Dockerfile file file. Dockerfile can be viewed as a script interpreted and translated by a Docker program lock. It is a collection ...

Posted on Sun, 17 Nov 2019 19:17:10 -0500 by webdogjcn

Troubleshooting of MySQL nested query "LIMIT & IN/ALL/ANY/SOME"

This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' Error message: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' Recently, there is such a requirement in the development process. To get the scores of the top 50 students in all subjects, first think of in (...). The ...

Posted on Sun, 17 Nov 2019 15:12:57 -0500 by dmonares

PHP full stack learning notes 28

Database Mysql overview, database operation, data table operation, data type, management database order by asc; ascending desc descending order sql standard language: Data query language select Data definition language create/alter/drop Data operation language insert delete update grant revoke, a data control language, gives user ...

Posted on Sun, 17 Nov 2019 14:23:35 -0500 by ctcp

There are 8 SQL misuses that are often ignored. Have you ever stepped on a pit?

1. LIMIT statement Paging query is one of the most commonly used scenarios, but it is also the most prone to problems. For example, for the following simple statements, the general way DBA s think of is to add a composite index to the fields of type, name, create "time. In this way, conditional sorting can effectively utilize index and i ...

Posted on Sun, 17 Nov 2019 14:14:06 -0500 by cornelombaard

Why JDBC driver class loading destroys parent delegation mechanism

As you all know, the class loading mechanism of jdk is the parent delegation mechanism. When we need to load a class, for example, the following situations new an object of a class Calling static members (except for final constants) and static methods of a class Using the method of java.lang.reflect package to make reflection calls on classes ...

Posted on Sun, 17 Nov 2019 12:57:45 -0500 by markmh84

Data service analysis of Spark project

First time included Specific steps of offline data calculation For the first time, there will be an original data. First, do the following: Create a directory of / people on hdfs and copy the csv file to it -- stay hdfs Create on people_in bin/hadoop dfs -mkdir /people bin/hdfs dfs -mkdir -p /people -- Local people01.cs ...

Posted on Sun, 17 Nov 2019 11:30:57 -0500 by sirmanson

Installing binary mariadb

Let's download the required binaries from the official website belowhttps://downloads.mariadb.org/mariadb/10.2.3/#bits=64After downloading, we can also check md5 to ensure that the package is not damaged during transmission and there will be no strange problems during installation 1 Prepare users and groups groupadd -r -g 336 mysql useradd -r ...

Posted on Sun, 17 Nov 2019 11:11:13 -0500 by Kevmaster

Full backup and restore of mysql database using mysql dump

1 > start database binary log Check whether SQL log bin is enabled MariaDB [(none)]> show variables like 'sql_log_bin'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | sql_log_bin | ON | +---------------+-------+ 1 row in set (0.00 sec) Use set SQL log bin = on; turn on binary log Modify profileSpecif ...

Posted on Sat, 16 Nov 2019 17:17:58 -0500 by creatives

Spring boot Jpa add object field use database default

jpa is used as the persistence layer framework. The database fields in the project have default values and non empty constraints, so it is necessary to save a complete object when saving objects. However, in development, we usually only save some special fields first, and use the database default values for the rest fields. If we directly use i ...

Posted on Sat, 16 Nov 2019 16:50:46 -0500 by biba028

Pit encountered in production butt test

background The production environment is deployed on the cloud server, and the data is stored in the cloud database. The default configuration may not be consistent with the test environment. So if you don't know the default configuration in advance and make corresponding modifications, you may encounter some pits. This is mai ...

Posted on Sat, 16 Nov 2019 13:06:03 -0500 by jemrys