How can mysql be corrected?
SELECT (select replace ('500x1x10', 'X', '*') AS a)/5000; the result is 0.1, but it is actually 1. how to correct it?
Reply to discussion (solution)
String expressions are not computed.Mysql does not have functions similar to eval. maybe you can write For your example, you can writeSELECT substring_index (a, '*', 1) * substring_index (a, '*', 2), '*',-1) * substring_index (, '*', 3), '*',-1)From (select REPLACE ('500x
configuration file# Customize location of the Docker binary (especially for development testing) . #DOCKER = "/usr/local/bin/docker" # Use Docker_opts to modify the daemon startup options. #DOCKER_OPTS = "--dns 8.8.8.8--dns 8.8.4.4 "# If you need Docker-to-use a HTTP proxy, it can also be specified here.export http_proxy=" Http://xxxx:port "# Thi S is also a handy place to tweak where Docker ' s temporary files go. #export tmpdir= "/mnt/bigdrive/docker-tmp" docker_opts= "- -insecure-registry dl
configuration file# Customize location of Docker binary (especially for development testing).#DOCKER="/usr/local/bin/docker"# Use DOCKER_OPTS to modify the daemon startup options.#DOCKER_OPTS="--dns 8.8.8.8 --dns 8.8.4.4"# If you need Docker to use an HTTP proxy, it can also be specified here.export http_proxy="http://xxxx:port"# This is also a handy place to tweak where Docker's temporary files go.#export TMPDIR="/mnt/bigdrive/docker-tmp"DOCKER_OPTS="--insecure-registry dl.dockerpool.com:
:
layerinfo:inmemory
filesystem:
rootdirectory:/var/lib/registry
Delete:
enabled:true
http:
Addr: 5000
The warehouse service needs to be restarted after the modification is complete.
$ sudo systemctl restart Docker-distribution.service
Use
First look at what mirrors are in the warehouse
$ python registry.py-r http://localhost:5000
To test the need, we first create a f
Tags: vsx MSU optimizer He also Foo mac SIG FAs TSXMSSQL provides us with two commands for dynamically executing SQL statements, namely EXEC and sp_executesql. Typically, sp_executesql has the advantage of providing an input-output interface, while Exec does not. One of the biggest benefits is the ability to reuse the execution plan with sp_executesql, which provides execution performance (which I'll explain in more detail in a later example), and can
Docker Warehouse Warehouses are places where image files are centrally stored. Sometimes the warehouse and the warehouse registration server (Registry) are confused, not strictly differentiated. In fact, the warehouse registration server often holds multiple warehouses, each of which contains multiple mirrors, each with a different label (tag).a Docker Registry can contain multiple warehouses ( Repository ); Each warehouse can contain multiple labels ( Tag ), and each label corresponds to a mir
/ Libstdc++.so.6 "for
file in $bak _list
does
cp-r $file/data/gcc-bak/
Done
Then, create the following file in the/etc/ld.so.conf.d/directory
Cat gmp-mpfr-mpc.conf
/usr/local/mpfr-2.4.2/lib/
/usr/local/mpc-0.8.1/lib/
/usr/local/gmp-4.3.2/lib /
Then extract the/tmp/lib.tar.gz into the/usr/local directory and perform the Ldconfig update cache.Try yum to install rpm
Yum Install gcc-4.8.4-1.x86_64.rpm
Find that too much reliance is missing
Finally, the dependency forcing update is ignored
different, they are behind Nat; otherwise, they are behind Nat. To detect different types of NAT, the STUN Protocol defines message attributes and requires the server to have different actions, such as using different IP addresses and ports when sending responses, or changing ports. The STUN Protocol may be effective for Nat, but it is powerless for the firewall, because the firewall may not open the UDP port.
Nat category
Stun roughly divides NAT into four types: Full cone, restricted cone, po
specifies the domain
-- Help: displays help.
-- Version: displays the version information.
Keys [root @ Jesse ~] # Cat c.txt
7 July
8 August
9 September
10 October
11 November
12 December
1 January
2 February
3 March
4 L
5 May
6 June
[Root @ Jesse ~] # Sort-c c.txt
Sort: c.txt: 4: disorder: 10 October // it indicates that the data is not arranged in a certain order. if nothing is displayed, it indicates that the data is classified in a certain
Mysql transactions, concurrency issues, lock mechanisms, mysql transactions1. What is a transaction?
A transaction is a combination of one or more database operation statements. It has four features: ACID.
Atomicity
Isolation: transactions are independent of each other and do not interfere with each other.
Consistency: After the database changes its status correctly, the consistency constraints of the database are not damaged.
Persistence: the transaction commit result, which is permanently stor
When the Docker Registry V2 comes out, it's really good to be simple and practical, but when you change port 5000 to something else, or use a domain name binding, it's a mistake. Here is a detailed record of the process of your own experience.First, the installation of Docker Registry V2 (distribution).Here I chose to use the official provided image to install, perhaps you will feel that it is easy, dismissive. However, for an OPS person, the attentio
different regions, there must be a solution to achieve interconnection between the two, so the atm lane technology came into being. By using LANE, the ATM network can simulate the work of the LAN, so that multiple LAN can be connected to the ATM network without any modification. ATM is responsible for bridging, which is completely transparent and seamless for users. It seems to work in a pure Ethernet environment, as shown in figure 2.
The configuration process of LANE is complicated, and the
layer configuration and defense, but it also simplifies load balancing and SSL settings. And more importantly, the reverse proxy server can be well integrated with the existing infrastructure.3. Hello NginxWe also try to play the Nginx based on Docker.//拉取Nginx镜像$ docker pull nginx//启动Nginx容器$ docker run -d -p 8080:80 --name hellonginx nginxAbove we started in the background running a nginx container named Hellonginx, whose port is mapped to the host's 8080 port, we can now be directly accessed
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.