欢迎光临!
Log In
  • 设置菜单

CTO-IT Technology

IT Club

×
MENU
  • Home
  • Python
  • Mysql
  • Linux
  • Mongodb
LocationHome

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...
2019-09-19 Mysql Comment
Read More

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 ...
2019-09-11 Mysql Comment
Read More

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...
2019-09-11 Mysql Comment
Read More

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...
2019-09-11 Mongodb Comment
Read More
MongoDB - Too Many open files Mongodb

MongoDB – Too Many open files

Mongodb always meat the error too many open files, then the deam process crashed. In Linux system, t...
2019-09-10 Mongodb Comment
Read More
Install pycurl problems Python

Install pycurl problems

install pycurl with problems curl-config and ssl libs In centos 7 and python 3.6 environment, instal...
2019-08-21 Python Comment
Read More

Install Pycurl deal some possible problems

In Centos 7 system, Python 3.6 environment, use pip3 install the pycurl modal, may have two problems...
2019-09-10 Linux Comment
Read More

CANNOT OPEN SHARED OBJECT FILE: NO SUCH FILE OR DIRECTORY

This maybe you delete the shared lib file soft link. So must execute a system command to rebuild the...
2019-09-10 Linux Comment
Read More
Accelerating DNS parsing with pdnsd Linux

Accelerating DNS parsing with pdnsd

Pdnsd is a good DNS parsing software in linux system. Compared with bind and dnsmasq, pdnsd has one ...
2019-09-01 Linux Comment
Read More

文章导航

Page 1 Page 2

SEARCH

AD

RECENT ARTICLE

  • OrderedDict and json loads keep the origin order
  • Python html escape and unescape
  • Mysql delete the duplicate records, leave only one record
  • Mysql master slave sync error: the slave’s relay log is corrupted
  • pip3 +python3.7 Error: There was a problem confirming the ssl certificate

HOT TAGS

max open files update Tornado pycurl centos qrcode yum mysql partition mysql zbar python SSLError pip3 SSLError CACHING_SHA2_PASSWORD mongodb from_days modify to_days ldconfig pdnsd
Copyright ©  CTOWAY

Log In Lost ?

Please enter your username or email address. You will receive a link to create a new password via email.

  • Directory
  • 繁