Programming VIP

We have learned about Spring Cloud Config before: Consul configuration center of Spring Cloud series (I) Consul configuration center of Spring Cloud series (2) Consul configuration center of Spring Cloud series (3) It provides the function of configuration center, but it needs to cooperate with git, svn or external storage (such as various da ...

1, Date and time functions 1. Function to get the current dateIt's the same. It's different CURDATE() : Used to get the current date of the system CURRENT_DATE() Used by the system to get the current date mysql> select CURDATE(),CURRENT_DATE(); 2. Get function of current time CURTIME() : Used to get the current time of the system mysql& ...

Use Prometheus and Grafana to monitor MySQL server performance.Use two exporter s:Node? Exporter: server system data collectionmysqld_exporter: MySQL server data collectionMonitoring architecture: Prometheus installation configurationInstallation mode binary installation, see here for details CentOS7 deployment PrometheusVersion: current late ...

check constraint means to filter one or more columns according to certain preset rules. If the condition is true, the filtering succeeds; if the condition is false, the filtering fails and the failure code is returned to the client. Why do you want to list and write this separately? You often encounter irregular SQL. In many cases, you can onl ...

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 ...

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 ...

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 ...

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 ...

[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 ...

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 ...