MySQL 8.0 InnoDB supports instant add column

Original address: https://mysqlserverteam.com/mysql-8-0-innodb-now-supports-instant-add-column/   For a long time, instant DDL has been one of the most popular InnoDB functions. For the growing and fast-growing data set, any network scale database must have the function of executing DDL immediately. Developers often need to add new columns to m ...

Added by coolfool on Tue, 12 May 2020 16:55:02 +0300

Mysql user management related

Currently used user and host: mysql> select USER(); +----------------+ | USER() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) Add user Before mysql 5, you can directly use INSERT to INSERT mysql users into mysql tables. You can't do this after mysql 5 mysql> insert into mysql.user(Ho ...

Added by snap2000 on Mon, 11 May 2020 19:06:52 +0300

My first JDCB program

1, Create your own database Download and install MySQL 1.windows Download: http://dev.mysql.com/downloads/mysql/ 2. Open the server: enter the bin directory of the download path in the terminal (cmd), and execute mysqld -- initialize executor to start the server and initialize, but an error will be reported. The reason is that there is no data ...

Added by _giles_ on Mon, 11 May 2020 07:51:35 +0300

Database learning 7: MySQL client tools and SQL introduction

7, MySQL client tools and SQL introduction 1. Syllabus: mysql client command introduction; How to get help from mysql; Management database of DDL statements; DDL statement management table and case introduction; Data in management table of DML statement; SELECT to retrieve data; 2. mysql interface program and SQL introduction mysql client comma ...

Added by jdimino on Fri, 08 May 2020 16:47:04 +0300

[2020Python cultivation] MySQL view, trigger, transaction, stored procedure and function

[contents] (the rest are knowledge) A view Two triggers Three Affairs (mastery) Four stored procedures Five functions Vi. process control 7, Index theory   1, View 1. What is a view A view is a virtual table (non real existence). Its essence is to get a dynamic data set according to SQL statements and name it. When users use it, they only ne ...

Added by csplrj on Fri, 08 May 2020 11:46:25 +0300

Mixed query of tp5+Mongodb and Mysql database

Preface MongoDB mass data query is fast without data model Suitable for log database Or the intermediate database reads and stores some business data to be read from the MySQL database MongoDB is not suitable for multi table transaction function, and there is not a good determination mechanism for write operation. It is not suitabl ...

Added by steved on Tue, 05 May 2020 01:46:33 +0300

Elastsearch basic query (open)

Elastsearch basic query Elasticsearch is a very powerful full-text search engine. The purpose of using elasticsearch is to quickly query the desired data. Basic query: query with elastic search built-in query criteria Composite query: a composite query that combines multiple basic queries Filter: when querying, filter out the desired data ...

Added by natronp on Mon, 04 May 2020 06:30:21 +0300

HAProxy https configuration, four-tier load balancing, and access control for load balancing services

In the previous section, we talked about the configuration of haproxy's access control ACL. For a review, please refer to https://www.cnblogs.com/qiuhom-1874/p/12817773.html ; Today let's talk about the configuration of haproxy's https, tcp-based four-tier load balancing, and access control. First let's look at the configuration of haproxy's ht ...

Added by amandas on Sun, 03 May 2020 09:12:33 +0300

Three methods of mysql copying table data and table structure

1, Copy table structure Method 1: mysql> create table a like users;         //Copy table structure   Query OK, 0 rows affected (0.50 sec)      mysql> show tables;   +----------------+   | Tables_in_test |   +----------------+   | a              |   | users          |   +----------------+   2 rows ...

Added by Dj_Lord on Sun, 03 May 2020 04:02:36 +0300

Spring boot (9): spring boot uses Druid data source

Druid is a database connection pool implementation on Alibaba open source platform. It combines the advantages of C3P0, DBCP, PROXOOL and other DB pools, and adds log monitoring. It can monitor the connection of DB pool and the execution of SQL. It can be said that Druid is a DB connectio ...

Added by hpg4815 on Sun, 03 May 2020 00:27:55 +0300