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