Programmer Think

Basic use of Mybatis Learning objectives Meet Mybatis Learn about Mybatis features Know why to learn Mybatis Use Mybatis to write a simple program Learn to use the basic functions of Mybatis Understand the basic configuration of Mybatis 1, Meet Mybatis Official documents 1. Introduction MyBatis was apache An open source project ...

1, MySQL 5 6 and MySQL 5 7 difference between bostorg was added at cmake Use mysqld --initialize instead of MySQL during initialization_ install_ DB, other parameters remain unchanged: - user= --basedir= --datadir= --initialize generates a temporary password You can also use another parameter -- initialize execute [root@dba-01 ~]# yum instal ...

1. Initial MySql 1.1 why learn database? 1. Job skill demand 2. In today's world, those who get data get the world 3. Method of storing data 4. How to keep a large amount of data in programs and websites for a long time? 5. Database is almost the core of software system. 1.2. What is a database? DataBase (DB for short) Concept: it is a ...

This note is the learning note of coursera website course Databases and SQL for Data Science with Python In this module you will learn the basic concepts related to using Python to connect to databases. In a Jupyter Notebook, you will create tables, load data, query data using SQL, and analyze data using Python After completing this module, y ...

2021SC@SDUSC summary PostgreSQL code I am responsible for: query compilation and execution Analysis content of this blog: Query Optimization - generate plan The whole process of query optimization can be divided into three stages: preprocessing, generating path and generating plan. In the last blog, I analyzed the process of generating the ...

Experiment 12 SQL + content Provider experiment 1, Experimental purpose Be familiar with the use of Content Provider; 2, Experimental content 1. Implement the calling of ContentProvider and ContentResolver through URI; 2. Realize the functions of ContentProvider on database SQLite: add, delete, modify and query; 3. The table structure of th ...

transaction management In short, I need to manage these affairs, hahaha So why is there such a thing? Because when the program is in the concurrent state, the data may be read and modified by multiple people at the same time, and errors will occur. Therefore, transaction management is required Possible errors in concurrent state: Type I ...

This article was originally published on my blog: https://ziyang.moe/article/mydb7.html The code involved in this chapter is https://github.com/CN-GuoZiyang/MYDB/tree/master/src/main/java/top/guoziyang/mydb/backend/vm Yes. preface This section will conclude the VM layer, introduce the possible version jump caused by MVCC, and how MYDB can av ...

introduction: MongoDB is a very promising database. The official positioning of MongoDB is a general database. In fact, this positioning is somewhat similar to MySQL. Although its popularity is far from reaching the level of MySQL, the author may make an inappropriate comparison. MongoDB, like MySQL N years ago, will become more and more powerf ...

redis detailed notes xxd 2021 / 12 / 03 Beijing 1, Getting started with redis redis installation 1. Download redis-5.0 7.tar. GZ and put it in our Linux directory / opt 2. In the / opt directory, unzip the command: tar -zxvf redis-5.0 7.tar. gz 3. After decompression, a folder appears: redis-5.0 seven 4. Enter the directory: CD redis-5. ...