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