Test high pay must see: 5 steps to teach testers how to quickly solve database queries
Mysql query questions, not only has a high exit rating, but also has a great impact on salary negotiation, so it plays an important role. 1. Almost all software test questions will have Mysql query exercises. Large companies with high salaries will select more excellent testers because of the number ...
Posted by kylevisionace02 on Wed, 04 Mar 2020 01:40:49 -0800
Search with MySQL regular expression
MySQL must know must know
Regular expressions are special strings (character sets) used to match text.
Three tables used: customers, products, and vendors
Basic character matching: the keyword REGEXP is followed by a regular expression
#Retrieve all rows of column prod'u name containing text '1000'
...
Posted by tofi84 on Tue, 03 Mar 2020 23:24:17 -0800
Introduction to libdbclient interface
This is a magical development interface!
It supports access to mysql, sqlite, Dream and oracle databases!
It provides a unified C++ abstract interface externally, hides the internal implementation details, and has a learning cost of 0 for users!
It provides abstract result table objects (result_ta ...
Posted by khovorka on Tue, 03 Mar 2020 19:51:13 -0800
Spark SQL dataframe, DataSet and RDD
Spark SQL directory
DataFrame
DataSet
RDD
DataFrame, conversion between DataSet and RDD
DataFrame, relationship between DataSet and RDD
The commonness and difference between DataFrame, DataSet and RDD
1.Spark SQL
Spark SQL is a module used by spark to process structured data. It provides two progr ...
Posted by tracivia on Tue, 03 Mar 2020 19:25:20 -0800
MyBaits - CRUD operations, alias configuration, attribute configuration, query result mapping, Mapper components, parameter processing, annotation development for MyBatis
Catalog
CRUD Operation of MyBatis
2. MyBatis Expansion
1. Alias Configuration Processing
1.2, Custom Alias
1.3. Aliases that come with the system
2. Attribute Configuration Processing
3. Query Result Mapping
3.1. How to alias fields
3.2, resultMap element
4. Mapper Components
4.1, Mapper ...
Posted by MorganM on Mon, 02 Mar 2020 17:34:33 -0800
Year open source SQL audit platform installation and use
1, Introduction to year
year is the MYSQL SQL statement audit platform. Provide query audit, SQL audit and other functions.
The edition of year 1. X needs the function of SQL audit and rollback provided by inception.
Since year 2.0 does not need to rely on perception, it has implemented SQL audit / rollback function th ...
Posted by sasa on Mon, 02 Mar 2020 01:43:58 -0800
MyBatis source code parsing -- MyBatis initialization process parsing
1. Preparation
To see the whole initialization process of MyBatis, first create a simple Java project. The directory structure is shown in the following figure:
1.1 Product entity class
public class Product {
private long id;
private String productName;
private String productCo ...
Posted by youngsei on Sat, 29 Feb 2020 23:25:01 -0800
Detailed tutorial of python nss module
I usually like making python modules. Recently, I made a module "nss" (which is used for database) and I uploaded it to pypi.
... First, you can download this module with 'pip install nss'. Because the size of the module itself is relatively small and the download is relatively fast, it can be ...
Posted by ckdoublenecks on Fri, 28 Feb 2020 03:47:14 -0800
Chapter 2: basic configuration of Spring Boot2.x
Chapter 2: basic configuration of Spring Boot2.x (in continuous update Updated February 27)
Summary of this chapter
What is annotation?
What are the core annotations of Spring Boot2.x?
What is auto configuration?
How can we extend our application with auto configuration feature?
Let's take a small ex ...
Posted by 14zero on Thu, 27 Feb 2020 02:01:55 -0800
Linux operation and maintenance - disk storage - 2. RAID
With the limitations of single disk in data security, performance and capacity, RAID has emerged. RAID combines multiple independent disks in different ways to form a disk group to obtain higher data security, performance and capacity than single disk.
1, Common RAID levels
Raid has several levels of RAID0~RAID7. In addition, there are some co ...
Posted by simplyi on Thu, 27 Feb 2020 01:15:44 -0800