Table partition (horizontal) operation record 2 of SQLSERVER

1 ---- (non original, just sort out the records by yourself!!!)--------------- Original address: https://www.cnblogs.com/libingql/category/184251.html     1. Of course, many test data are needed to useGenerate test data. For example, I operate with 10000000 million data   1. It is applicable to the partition operation of existing data tables. O ...

Posted by yacaph on Sun, 17 Apr 2022 11:23:50 +0300

PostgreSQL learning summary -- PostgreSQL multi tenant analysis based on database and schema

Multi tenancy based on DATABASE 1. Advantages The way of database isolation is relatively complete, and there are few shared resources. Storage isolation can be realized; connection isolation can be realized; The isolation of auth can be realized; Permission isolation can be realized. Isolation starts from the authentication level, and there ...

Posted by markbm on Sat, 16 Apr 2022 00:06:43 +0300

MyBatis beginner's quick start 01 (basic use of addition, deletion, modification and query)

premise 1. Understand database, JDBC, maven and other basic knowledge. 2. This paper uses idea and maven to illustrate. 1, Introduction to MyBatis 1. Official profile MyBatis is an excellent persistence layer framework, which supports custom SQL, stored procedures and advanced mapping. MyBatis eliminates almost all JDBC code and the wor ...

Posted by fox_m on Fri, 15 Apr 2022 17:37:59 +0300

Spring Cloud learning notes (3 / 3)

108_ Installation of Linux version of Nacos Expected, 1 Nginx+3 nacos registries +1 mysq Make sure you are installing and using in the environment: 64 bit OS Linux/Unix/Mac, Linux system is recommended.64 bit JDK 1.8+; Download to configure.Maven 3.2.x+; Download to configure.Only three or more Nacos nodes can form a cluster. link Nacos d ...

Posted by Lee on Fri, 15 Apr 2022 08:30:50 +0300

MySQL notes (dark horse III)

DQL: query statement Sort queryAggregate functionGrouping queryPaging query constraintRelationship between multiple tablesnormal formBackup and restore of database DQL: query statement Sort query Syntax: order by clause order by sort field 1, sort by 1, sort field 2, sort by 2 Sort by: ASC: ascending, default.DESC: descending. ...

Posted by cheesehead on Fri, 15 Apr 2022 02:36:28 +0300

MySQL connection query

Create sample table Creation of Table 1 create table Double list 1 ( id int PRIMARY key, name varchar(30) ) insert into Double list 1 select 1,'Xiao Ming'; insert into Double list 1 select 0,'Zhang San'; insert into Double list 1 select 0,'Boiling sheep'; insert into Double list 1 select 0,'Li Yang'; insert into Double list 1 select 0,'G ...

Posted by goa103 on Thu, 14 Apr 2022 00:47:29 +0300

MySQL exercises ~ 45

Create tables and add data -- classic SQL Exercises CREATE TABLE STUDENT8 (SNO VARCHAR(3) NOT NULL, SNAME VARCHAR(4) NOT NULL, SSEX VARCHAR(2) NOT NULL, SBIRTHDAY DATETIME, CLASS VARCHAR(5)); CREATE TABLE COURSE (CNO VARCHAR(5) NOT NULL, CNAME VARCHAR(10) NOT NULL, TNO VARCHAR(10) NOT NULL); CREATE TABLE SCORE (SNO VARCHAR(3) NOT NULL, CNO ...

Posted by _confused_ on Wed, 13 Apr 2022 00:52:46 +0300

Chapter 3 relational database standard language SQL

Chapter 3 relational database standard language SQL The whole content of this paper comes from the introduction to database system (5th Edition) - written by Wang Shan and SA Shixuan 3.1 SQL overview Comprehensive unificationHighly unprocessedSet oriented operation modeProvide multiple ways to use the same syntax structureThe grammar is ...

Posted by khovorka on Mon, 11 Apr 2022 19:09:21 +0300

Installation steps, basic commands and related functions of Ubuntu Linux C sqlite3

catalogue sqlite3 installation steps sqlite3 basic commands Enter sqlite mode command System command (point command -- with "." (beginning) sqlite statement (with ";) (end) sqlite related functions C/C + + interface (header file #include) sqlite3_open() sqlite3_close() sqlite3_exec() Callback function: sqlite3_get_tabl ...

Posted by affordit on Mon, 11 Apr 2022 09:22:29 +0300

Creation of partition table of ORACLE

What is a partition table? Why use partition table? How to create a partition table? If the data in a table in your database meets the following conditions, you should consider creating a partitioned table. 1. There are a lot of data in a table in the database. What are many concepts? Ten thousand? 20000? One hundred thousand or one million? T ...

Posted by Garrett on Mon, 11 Apr 2022 09:20:24 +0300