Build mysql database, and mysql common high-frequency commands -- database
Build mysql database and mysql common high-frequency commands
I. environment construction
II. Common commands
2.1 database operation
2.2 data table operation
2.3 view operation
2.4 data operation (add, delete, modify and query)
I. environment construction
This paper only builds learning in windows environment.
Downlo ...
Posted by nealios on Mon, 25 Nov 2019 14:17:48 -0800
MySQL - Indexed View Transactions, Storage Engines MyLSAM and InnoDB (Actual!)
The role of indexes
With the appropriate index set, the database can greatly speed up the query speed by utilizing various fast positioning techniques.
Especially when the table is large or the query involves multiple tables, using an index can speed up the query thousands of times;
The IO cost of the database can be reduced, and the index can ...
Posted by Shai-Hulud on Mon, 25 Nov 2019 14:14:21 -0800
Spring boot uses redis through redisTemplate without manual serialization
For some operations of redisTemplate, please refer to the following two articles http://blog.csdn.net/whatlookingfor/article/details/51863286 http://www.jianshu.com/p/7bf5dc61ca06
Import redis dependency
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spr ...
Posted by departedmind on Mon, 25 Nov 2019 12:58:04 -0800
django's routing layer
Catalog
How to establish orm table relationship
One-on-one
One to many
Many to many
django request lifecycle flowchart
url.py routing layer
Route matching
django matching routing law
Cancel the function of django to automatically slash the browser
Restrict th ...
Posted by ganeshcp on Mon, 25 Nov 2019 11:31:01 -0800
Django-40-ORM many to many new
Premise (initial table data)
The book table and the author table are many to many relationships. A book may have multiple authors, and an author may have multiple books
add(* []): can be number (i.e. id); object; object list
book table
author table
Book & authors table (relational table)
Django ABCD study.app01. ...
Posted by samba_bal on Mon, 25 Nov 2019 09:03:07 -0800
javalist for paging data to page
Because a page of the project is displayed from multiple sources, it is impossible to query the database and page, and the data volume is not large, so I have to use memory page, but I am stupid. I found a page on the Internet for half a day to improve it to fit me, and finally finished paging, but the current barrier has beco ...
Posted by labmixz on Mon, 25 Nov 2019 07:59:49 -0800
MySQL open remote login
1. Log in MySQL database
mysql -u root -p
View user table
mysql> use mysql;
Database changed
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+--------------------- ...
Posted by prc on Mon, 25 Nov 2019 07:44:31 -0800
High availability of MHA for mysql
I. Introduction to MHA
Author brief introduction
Song xinjiafan:
MySQL/Linux expert
Sony in 2001
oracle started in 2001
Started using MySQL in 2004
September 2006 August 2010 MySQL Consultant
2010-2012 DeNA
2012 ~ now Facebook
Software introduction
MHA can realize automatic fault detection and failover in a short time, usually within 10-30 se ...
Posted by ExpertAlmost on Mon, 25 Nov 2019 03:45:11 -0800
Read "unstated and unstated-next source" in detail
1 Introduction
unstated Class Component-based data flow management database, unstated-next It is an upgraded version of Function Component with special optimization for Hooks support.
Compared with redux-like libraries, this library is designed to be unique, and the source lines of both libraries are exceptionally small. Untated-next has less t ...
Posted by sdat1333 on Sun, 24 Nov 2019 18:29:50 -0800
Springboot 2.0+activiti 7 Integration--Create your own business process
With the activiti framework, you first need to create a bpmn flowchart. There are two choices: one is the plug-in that comes with the ide (eclipse is good, not to mention it; the other is the plug-in that is really hard to use and has not been updated for several years); the other is the tool that activiti officially provides. activiti-app (Ver ...
Posted by neroag on Sun, 24 Nov 2019 11:36:53 -0800