Server: alicloud server
Operating system: CentOS 6.8
mysql version: 5.5
Download and unzip mysql
1> cd /usr/local/
2> mkdir mysql5.5
3> rz [Select localmysql-5.5.59-linux-glibc2.12-x86_64.tar.gz] ...
Posted on Wed, 01 Apr 2020 19:09:54 -0700 by behzad
1. Check which libraries are available
> show databases;
2. View the table of a library
> use db1; show tables;
3. View the fields of the table
> desc tb1;
4. View the statement of table creation
> show create table tb1;
5. Which user is it currently
> select user();
6. View the current library
> select databa ...
Posted on Wed, 01 Apr 2020 09:42:57 -0700 by phil88
The application side needs to generate the sequential increasing sequence to make the pipeline sequence number. The schemes are as follows: 1. redis /MySQL SEQUENCE engine generates the sequence; 2. Mysam table replace into mode in MySQL; 3. innodb table insert... On duplicate key mode ...
Posted on Wed, 01 Apr 2020 09:08:18 -0700 by anybody99
20.20 main script of alarm system
Define the main script in / usr/local/sbin/
mkdir bin conf shares log mail
Main script under bin
• main.sh content
#Written by aming.
# Whether to send mail
export send=1 //All monitored items will be emailed. export means that all v ...
Posted on Tue, 31 Mar 2020 15:52:13 -0700 by sxiix
Overview of slow query log
The so-called slow query log is used to record SQL statements with response time exceeding the set threshold in MySQL. By turning on the slow query switch, MySQL will record SQL with response time greater than the threshold in the log for performance analysis.
The slow query log option is off by default. If you want t ...
Posted on Tue, 31 Mar 2020 14:44:01 -0700 by misteraven
pip3 download pymysql Python operation Mysql
pip3 install pymysql
2. Use pymysql
#------------------1. Execute SQL---------------------------
# Create connection
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='654321', db='t1',charset='utf8')
Posted on Tue, 31 Mar 2020 07:04:26 -0700 by Errant_Shadow
Today, for the first time, we used multi table rollback and encountered a pit. The error code is as follows:
$Member = D("Member");
$member_condition['id'] = 11641;
$member_data['id'] = 10000;
$member_res = $Member->where($member_condition)->save($member_data);
Posted on Tue, 31 Mar 2020 00:19:34 -0700 by abhijeet
Author: Ma yingle
A member of the research and development team of akesheng, responsible for the testing of mysql middleware and database management platform. Good at finding fault (testing technology enthusiasts), welcome to try dtle~
Source: original contribution
*Aikesheng is produced by the open source community. The original content can ...
Posted on Mon, 30 Mar 2020 02:53:10 -0700 by Crysma
Configure mysql,jpa, etc
helloWorld: spring Boot\u5927\u7237\u ...
Posted on Sun, 29 Mar 2020 12:07:07 -0700 by hkay1
1, Error message
Recently, the project implementation colleagues upgraded the system and changed a field of test.test tab T1. The SQL statement is as follows:
ALTER TABLE TEST.TEST_TAB_T1 MODIFY BXXX VARCHAR(200);
After the system upgrade of the project, the MySQL master-slave synchronization error is reported as follows:
mysql>show slave ...
Posted on Sun, 29 Mar 2020 11:21:13 -0700 by gaz_hayes