Beego Learning Notes 6: Paging Implementation

Implement Paging 1> Business logic for paging implementation 1->N data are displayed on each page. For the total number of data records M, the number of pages M%N==0?M/N:M/N+1; 2->Page Rendering Paging html Part 3>Switch pages, input parameters, background processing, and retrieve new eligible data 4>Paging method, js paging, and ...

Posted by irishred8575 on Sun, 19 Jul 2020 07:40:52 -0700

MySQL Database Event Timer Execution Task

1. Background Because the business of the project is constantly moving forward, it is unavoidable that the number of tables in the database will become larger and larger, constantly squeezing hard disk space.Business growth cannot be sustained even with the greatest amount of space, so it is necessary to regularly delete unnecessary data.A tab ...

Posted by squizz on Sat, 18 Jul 2020 08:15:03 -0700

docker creates lnmp image

Docker is a lightweight virtualization technology, and lnmp is a powerful, open-source web running environment, so here's a demonstration of using Docker to build an lnmp image. PS: To maintain lightweight and scalable performance, Docker encourages us to "one process per person"Container"means don't integrate too many functions ...

Posted by webweever on Fri, 17 Jul 2020 07:56:18 -0700

docker creates lnmp image

Docker is a lightweight virtualization technology, and lnmp is a powerful, open-source web running environment, so here's a demonstration of using Docker to build an lnmp image. PS: To maintain lightweight and scalable performance, Docker encourages us to "one process per person"Container"means don't integrate too many functions ...

Posted by darkninja_com on Fri, 17 Jul 2020 07:58:04 -0700

Running multiple mysql instances on one machine

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Posted by mega_hurtz on Thu, 16 Jul 2020 09:08:28 -0700

Running multiple mysql instances on one machine

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Posted by mrinfin1ty on Thu, 16 Jul 2020 09:07:05 -0700

phpmyadmin connects databases on multiple servers at the same time

1. Scenarios for use In general, there are test environments and formal environments for our development.Of course, databases are also separate.If you could use phpmyadmin to directly access mysql on both servers.This is the need. 2. Solutions 1. Find under the phpmyadmin folderConfig.sample.inc.php, renamedConfig.inc.php. 2. OpenConfig. ...

Posted by jpaloyo on Wed, 15 Jul 2020 08:48:28 -0700

linux/window backup mysql database regularly

It is relatively simple for Linux to back up the database regularly. crontab can be used for scheduled backup. If windows is used, it may be troublesome. 1.Linux: Step 1: configure the backup directory code on the server: mkdir /var/lib/mysqlbackup cd /var/lib/mysqlbackup Step 2: write backup script code: vi dbbackup.shPaste the f ...

Posted by jara06 on Tue, 14 Jul 2020 09:05:18 -0700

Solving Chinese Scrambling Problem of mysql+python on mac Platform

First, for mysql databases, the default character is latin1 This latin1 is the culprit that we can't write in Chinese.The solution, then, is to change the character set to UTF-8 The easiest way to do this is to modify the windowMy.iniProfile),My.iniWhere and how to modify it to UTF-8 is as follows: https://www.cnblogs.com/Ray-xujianguo/p/332 ...

Posted by Yetalia on Sun, 12 Jul 2020 08:38:36 -0700

Deploy and install MySQL 5.6.23 on linux

download Download lrzsz first: upload mysql package on window s to linux yum -y install lrzsz Enter / usr/local directory rz: select mysql package Check if your computer has mysql installed ps -ef|grep mysqld root 2493 2423 0 19:48 pts/3 00:00:00 grep mysqld rpm -qa |grep -i mysql Unzip and rename the uploaded mysql ...

Posted by hmgroen on Thu, 02 Jul 2020 09:16:59 -0700