Programmer Group

1. Download MySQL 5.6.36 compile free installation package and upload it to / usr/local/src directory (you can also use wget command to download it directly to this directory) Download address https://yunpan.360.cn/surl_ymCGfFYt2Ya 2. Decompression [root@JSH-01 src]# tar zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz 3. Move the extracted file ...

This video makes a list of the blog's home page; Content introduction: springboot integrates beetlsql; uses for loop, if control statement, virtual property, variable definition, etc Learn beetl directory together: https://my.oschina.net/u/1590490?tab=newest&catalogId=6214598 Author: GK Integrate BeetlSql to query database Introdu ...

a moment of fun Me: Hey, madam, there's Iced Black TeaMadame: YesMe: How much is a bottleEmpress: 3 piecesMe: Give me a bottle, give it, three piecesMadame: Come on, your iced black teaMe: Play, I want Iced Black tea. Do you want a cap for me?Mrs. Boss: This is another bottle. My family is sold out. Go to the next house and have a change. Q ...

Multiple real columns and one principal and many subordinate Create a directory for database information [root@db200 ~]# mkdir /data/330{7..9} –p Create a file to hold the profile [root@db01 ~]# touch /data/330{7..9}/my.cnf Edit 3307 profile [root@db01 ~]# vim /data/3307/my.cnf [mysqld] basedir=/application/mysql datadir=/data/3307/data so ...

1. An error is reported when mysql deletes the primary key in the table, as shown in the following code: mysql> alter table student drop primary key; ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key 2. Cause of the problem: When viewing the types of the student table, it is fo ...

1. For the installation of percona toolkit, please refer to: https://blog.csdn.net/yuanyk1222/article/details/100066788 2. Here are some uses of this tool: pt-online-schema-change The function can organize the table structure online, collect fragments, and add fields and indexes to large tables. Avoid blocking read and write operations by lo ...

Foreword: When you execute a SQL in MySQL, the statement is not completed within the time you expect. We usually log in to the MySQL database to see if something is wrong. One of the commands we usually use is show processlist to see which session s are there and what they are doing.When you see waiting for table metadata lock, you encounter an ...

Guidance:This article mainly introduces the installation steps of MySQL 5.7.23 binary installation of CentOS system, and the installation process of other versions is similar. 1. Preparation Uninstall old MySQL View the rpm package rpm -qa|grep mysql if available Find mysql residue package, delete if any, and ignore if no find / -name ...

How to connect a mysql database with mysqli series functions? 1. PHP mysqli connect() function: mysqli connect() function opens a new connection to MySQL server. Syntax: mysqli connect (host (specify host name or IP address), username(mysql user name), password(mysql password), dbname (default database)) Open a new connection to the MySQL se ...

timestamp type partition, please move = > MySql table partition (based on time timestamp)Environmental Science:MySQL 8.0.18 (unverified for 5.6 and 5.7)The field type of partition condition is datetimeThe complete sql operation table partition statement is as follows: -- 1.Delete table drop table t_test; -- ============================== ...