Programmer Group

mycli helper github: https://github.com/fengjx/too... purpose It is more convenient to use MySQL command-line client mycli to connect to remote MySQL through ssh tunnel remote server port forwarding. The detailed usage of mycli can be found on the official website https://www.mycli.net/ Network topology Usually, we can't connect to the online ...

In Django, sqlite3 database is used by default. Today, I studied how to change it into a common mysql database. Because the project uses python3, and MySQL DB does not support the version of python3, if you use the version of python3.x, PIP install MySQL DB will report an error. Later, through Google, it was found that pymysql could be used i ...

MySQL password change Check whether MySQL service is started. If not, use / etc/init.d/mysqld start [root@test-a ~]# ps aux | grep mysql root 2180 0.0 0.1 115432 1724 ? S 07:33 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/usr/local/mysql/mysqld.pid mysql 2390 0.9 17.8 1117648 180356 ? ...

Using software: mysql, eclipse Link steps: 1. Registration driver 2. Create a connection object 3. Write sql statement 4. Execute sql statement and return a result or result set 5. Close the three connection objects (connection, statement and setresult). The closing order is (setresult -- > statement -- > setresult) I. direct connection m ...

CentOS Six.Five install MySQL 5.6 1. View system status [root@itzhouq Three 2 tools]# cat /etc/issue CentOS release 6.5 (Final) Kernel \r on an \m [root@itzhouq32 tools]# uname -a Linux itzhouq32 2.6.32-Four 31.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux 2. Create a directory to download rpm package [root@itz ...

We need to back up the database once a minute. Let's start. Create command file php artisan make:comman BackupDatabase Open the file you just created and change it to the following: <?php namespace App\Console\Commands; use Illuminate\Console\Command; use Symfony\Component\Process\Exception\ProcessFailedException; use Symfony\Component\Pro ...

Descending Indexes Descending index is mainly used to reduce sorting and remove filesort. MySQL supports descending index: DESC in index definition is no longer ignored, but key values are stored in descending order. Previously, indexes could be scanned in reverse order, but performance would be affected. It can scan the descending index in fo ...

The binlog log function of MySQL is used to record the updated contents (changes to the database) of MySQL database, such as the internal addition, deletion, modification and query of MySQL. The query select or show of the database will not be recorded by the binlog log log. It is mainly used for the master-slave copy and increment recovery of ...

As we all know, the index structure used by InnoDB is B + tree, but in fact, it also supports another index: adaptive hash index. Hash table is in the form of array + linked list. The hash bucket position corresponding to the key in each node data is calculated by the hash function. If there is a hash conflict, the zipper method is used to sol ...

1. Ensure that there is a dependent libaio software in the system. Use the following command [root@localhost ~]# yum -y install libaio [root@localhost ~]# rpm -q libaio libaio-0.3.109-13.el7.x86_64 2. Use wget command to download mysql-5.7.24 package [root@localhost ~]# wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.24-linux-glibc2.12 ...