It has been more than ten years since I wrote the code.
Most of the time, I don't start because I know where to go, I just know I can't stay anymore, that's all.After being hit by the wind and rain, there will be a lot of u ...
Added by theqase on Fri, 17 Apr 2020 23:57:07 +0300
How to get start command of container
The container has already been created. How to know its startup parameters (where to mount the data)
#Suppose you start a container with the following command
docker run -d --name mysql\
#How to kno ...
Added by fractalvibes on Mon, 13 Apr 2020 17:37:02 +0300
1. Environment configuration
Hosts configuration modify the / etc/hosts file and add wtcontroller, wtcompute1 and wtcompute2:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.16.10.101 wtcompu ...
Added by fastidious on Tue, 07 Apr 2020 12:54:15 +0300
Requirement: the exchange code of excel is imported into mysql, with a total of 30W pieces of data. Navicat has its own functions. It can directly import excel data into mysql. There are too many databases and manual operation is very troublesome. A script is written with python.
Use pip to import xlrd,pymysql library. ...
Added by uncleronin on Mon, 06 Apr 2020 19:22:11 +0300
1, Catalog description
① there is only one root directory in Linux/
② the contents stored in each directory of Linux are planned, and do not misplace files
③ Linux manages our devices in the form of files, so in Linux system, everything is files
Requirement: it is necessary to have a general understanding of what contents are stored in various ...
Added by auteejay on Sun, 05 Apr 2020 02:13:34 +0300
JDBC(Java Database Connectivity)
Java database connection specification (a set of interfaces) provided by Sun company
JDBC core class
DriverManager create connection
Connection connection class
Statement execute sql statement
ResultSet result set
JDBC connection steps
1. Registration driver
Added by thinguy on Sat, 04 Apr 2020 18:04:51 +0300
MySQL to achieve sequence effect
Generally, sequence is used to process primary key fields. There is no sequence in mysql, but MySQL provides an increment to achieve similar purposes, but it is only an increment, and cannot set step size, start index, cycle, etc. the most important thing is that a table can only be used by one field, but some ...
Added by mcgruff on Fri, 03 Apr 2020 19:14:24 +0300
When exporting, backing up and restoring Mysql database from the master database to the slave database, you need to pay attention to whether to enable GTID mode for the database. If you enable it, you should add the parameter -- set GTID purged = off to mysqldump data.
See reprint for details:
Here are the first 30 lines of a.sql exported with ...
Added by Jack_Slocum on Fri, 03 Apr 2020 08:48:03 +0300
MySQL 8 official version 8.0.11 has been released. It is officially said that MySQL 8 is two times faster than MySQL 5.7, and has brought a lot of improvements and faster performance!
The following is the record of my installation process on April 23, 2018. The whole process takes about an hour, and the make & & make install process tak ...
Added by BANDYCANDY on Thu, 02 Apr 2020 13:33:06 +0300
Functions in MySQL
Functions in MySQL include character function, numeric operator and function, comparison operator and function, date time function, information function, aggregate function, encryption function, etc.
1. Character function
//For example, when you need to output last name and first name togethe ...
Added by Yaak on Thu, 02 Apr 2020 02:25:26 +0300