OrderedDict is the sub object of dict, it will remember the origin order of the content. When compar...
Python html escape and unescape
Python escape or unescape html special words methods. 1、The cgi module that comes with Python has an...
Mysql delete the duplicate records, leave only one record
Here I will give a good SQL statement, it can delete the duplicate records and leave the min id reco...
Mysql master slave sync error: the slave’s relay log is corrupted
If the disk space is not enough, the mysql will not be login or the slave can't to write any data. I...
pip3 +python3.7 Error: There was a problem confirming the ssl certificate
Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection brok...
The CentOS common must install libs.
The new CentOS initial must install system libraries, which can make the system environment run smoo...
MYSQL date function: TO_DAYS() and FROM_DAYS()
1、to_days(date), change the date to a integer number days. mysql> SELECT TO_DAYS(950501); -> 728779 ...
MYSQL 8.0 ERROR：ERROR 2059: AUTHENTICATION PLUGIN ‘CACHING_SHA2_PASSWORD’ CANNOT BE LOADED
Error Message: error 2059: Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib6...
mongodb update command($inc/$set/$unset/$push/$pop/upsert/save)
In addition to replacement, only partial updates are needed for one or more documents. Atomic update...
Install Pycurl deal some possible problems
In Centos 7 system, Python 3.6 environment, use pip3 install the pycurl modal, may have two problems...