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