Programming VIP

Previously, Maven generator was used to generate code. There was a problem in the configuration file from single module to multi module, Use mybatis plus to generate code automatically instead. Code cloud address: https://gitee.com/baomidou/mybatis-plus github Address: https://github.com/baomidou/mybatis-plus rely on <dependency> ...

Database backup statement mysqldump -S /tmp/mysql3309.sock -u root -pMySQL8.0 \ --single-transaction \ --quick --flush-logs \ --triggers \ --routines \ --events \ --set-gtid-purged=OFF \ --databases testdb > testdb.dump The following data exists in table nw during backup mysql> select * from nw; +---------------------+ | dt ...

Continue the part of execution plan that was not completed last time6. The possible indexes used by possible keys. This understanding indicates the possible indexes used in query. It may be used, but not necessarily. If it is empty, there must be no relevant index. But if there is value, it may not be used.7. Index actually used by key.Let's l ...

Read commit of Mysql transaction isolation level View mysql transaction isolation level mysql> show variables like '%isolation%'; +---------------+----------------+ | Variable_name | Value | +---------------+----------------+ | tx_isolation | READ-COMMITTED | +---------------+----------------+ 1 row in set (0.00 sec) You can see t ...

The process of R & D often involves database changes, the repair of table structure and the modification of data. In order to ensure that each environment can be changed correctly, we may need to maintain a database upgrade document to save these records. The environment that needs to be upgraded will be upgraded according to the document. ...

Node.js ORM - Sequelize basic Overview: ORM(Object Relation Mapping) based on Promise supports multiple databases, transactions, associations, etc Installation: npm i sequelize mysql2 -S Basic use: const Sequelize = require("sequelize"); // Establish connection const sequelize = new Sequelize("kaikeba", "root", "admin", { host: "localhost" ...

A PHP+Ajax implementation of article mood voting function example, you can learn to understand the basic process of voting: get mood icon and histogram related data through Ajax, when the user clicks one of the mood icons, send a request to Ajax.php, PHP verifies that the user cookie prevents repeated submission, then adds 1 to the correspondin ...

1.1 tinyint description type length When not specified, the length is Occupying byte Range Signed Unsigned tinyint 3 4 1(8bit) -128~255 -128~127 0~255 id           tinyint(M)       [UNSIGNED]   [ZEROFILL] Field name field type length unsigned leading fill unsigned: 01: after tinyint(M) and unsigned, there is no sign (the range of tin ...

1. Start docker service [root@docker ~]# systemctl start docker 2. View the image in docker [root@docker ~]# docker images REPOSITORY TAG IMAGE ID CREATED SIZE centos/mysql-57-centos7 latest 2e4ddfafaa6f 6 months ago 445MB gogs/gogs ...

Find out the top three employees in the Department Staff table: +----+-------+--------+--------------+ | Id | Name | Salary | DepartmentId | +----+-------+--------+--------------+ | 1 | Joe | 85000 | 1 | | 2 | Henry | 80000 | 2 | | 3 | Sam | 60000 | 2 | | 4 | Max | 90000 | 1 | | 5 | Ja ...