1.1 Binary Pack Installation of MySQL Database
1.1.1 Pre-installation preparation (specification)
1 [root@Mysql_server ~]# mkdir -p /home/zhurui/tools ##Create the specified toolkit storage path
2 [root@Mysql_server ~]# wget http://Ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/mysql-5.5.32-linux 2.6- ...
Posted on Wed, 09 Oct 2019 05:11:46 -0700 by richrock
This article source code: GitHub. Click here || GitEE. Click here
Introduction to ClickHouse
1. Basic Introduction
Yandex open source data analysis database, named ClickHouse, is suitable for streaming or batch warehousing of sequential data. ClickHouse should not be used as a general database, but as a distributed real-time processing platfor ...
Posted on Tue, 08 Oct 2019 21:59:48 -0700 by ubersmuck
Look at these two leetcode database topics today
The Employee table contains all employee information, and each employee has its corresponding Id, salary and department Id.
| Id | Name | Salary | DepartmentId |
Posted on Tue, 08 Oct 2019 18:24:16 -0700 by MadDawgX
Resource from StackOverflow
How do I pass array parameters using stored procedures?
1. It's too troublesome to split and parse strings.
2. Add Sql Server custom type sp_addtype
Problem requirements: Array type parameters need to be passed to SP
select * from Users where ID IN (1,2,3 )
Sql Server ...
Posted on Tue, 08 Oct 2019 10:35:17 -0700 by Maq
The project uses spring data jpa,
After configuring many-to-one and one-to-many table object associations,
Colleagues found that there were two data inquiries from more than one party, and their data IDS were the same.
At first they thought it was Ali's json serialization, because of repeated references, circular references, which led to the ...
Posted on Tue, 08 Oct 2019 04:13:50 -0700 by melbell
The first method is to query all the data and then paginate it.
When paging, we need to get two parameters from the front desk, pageNo (which page data) and pageSize (the number of entries per page).
According to these two parameters, the data needed by the front end is to find the start index and the end index in the data list.
Posted on Tue, 08 Oct 2019 03:40:58 -0700 by cigardude
The main responsibility of mytatis executor is to translate jdbc operations, which is a very important function of mybatis.
The executor class diagram is as follows
- As can be seen from the figure above, all the executors implement the Executor interface, defining some general operations, and the Executor interface is defined as follows
Posted on Mon, 07 Oct 2019 22:41:45 -0700 by msinternet
mysql provides four types to store binary data:
TinyBlob can store up to 255 bytes
Blob can store up to 65KB
Medium Blob can store up to 16MB
LongBlob can store up to 4 GB
1 //from properties Loading database configuration in files
2 Properties properties = new Properties();
3 InputStream inputStrea ...
Posted on Mon, 07 Oct 2019 22:16:51 -0700 by gasper000
Here, for example, to crawl blog articles for reference only, some AD flying websites are too wasteful of the feelings of crawlers.
Use Beautiful Soup to get blog posts
Transfer Html to Markdown via html2text
Save Markdown to the local file
Download the image in Markdown to t ...
Posted on Mon, 07 Oct 2019 21:35:01 -0700 by dmcke5
Use of Druid Database Connection Pool
I. Basic use of Druid_
Druid: database connection pool implementation technology, provided by
1. Import the jar package druid-1.0.9.jar
* Don't forget to import database-driven jar packages
2. Define the configuration file:
* It's in the form of p ...
Posted on Mon, 07 Oct 2019 04:39:35 -0700 by emdee