Tag:mysql

  • Mysql lookups delete table duplicate data method summary

    Time:2019-10-23

    In the database table, we sometimes save a lot of duplicate data, the duplicate data waste resources, we want to delete it, what should we do? Let’s see. Let’s take a look at our table. Some of the data is repetitive. To find duplicate data, we can use the having statement in mysql, as shown […]

  • Mo tianlun document open test, three good gifts you take

    Time:2019-10-23

    Event detailsMok documents are organized by technical experts and uploaded to the database related solutions. Currently support PDF, PPT, WORD, TXT format files, users can browse all documents online free, but also through the ink value to download to the local. Now open beta, invite you to become a technical expert and upload documents, three […]

  • For SpringMVC learning

    Time:2019-10-23

    Learning web framework based on Spring combat One, the introduction Generally, before starting to learn a knowledge point, a small test project is built to help understand the problem. Therefore, I have built a basic simulation login platform, and input the password to jump to the page. Upload code on the yards cloud https://gitee.com/lingnancfy/… . […]

  • 10 lines of Python code, batch compression of 500 pictures, is too powerful

    Time:2019-10-23

    This article is original and first published on the public account [Python is a cat, without authorization, do not reprint.The original address: https://mp.weixin.qq.com/s/5hpFDgjCpfb0O1Jg-ycACw Readers familiar with “Python cat” should know that all of my posts use highly distinctive illustrations — cat for the original article and dog for the reproduced article, with rare exceptions. These […]

  • Improve performance, build MySQL read-write separation environment (1)

    Time:2019-10-21

    This is a scattered note before brother song. I’ll sort it out and share it with you! MySQL read-write separation is a very common requirement in Internet projects. Trapped in Linux and MySQL version problems, many people often fail to build. Today, brother song will give you a successful example. Later, I will share with […]

  • Delete database without running away – explain MySQL data recovery in detail

    Time:2019-10-21

    In daily work, there will always be some mistakes in deleting database tables and data caused by shaking hands, writing wrong conditions, writing wrong table names, and connecting the production database wrongly. Then, if you can’t recover the data, what DBAs are needed. Related articles MySQL backup strategy MySQL data recovery 1 Preface The premise […]

  • Generate crud production code of each table of MySQL, golang

    Time:2019-10-21

    When writing golang to connect mysql, you can’t escape the curd (add, delete, modify and query) operation.If ORM operation is used in production, performance will be affected. Only SQL operation generated from source is the best.If there are many tables, there are many duplicate codes. If there is a tool to produce curd code, it […]

  • A very interesting SQL optimization experience: from 30248.271s to 0.001s

    Time:2019-10-20

    Source: toutiao.com/i66682753333034148356 Author | Java technology architecture Background introduction My database is mysql5.6. The following is a brief introduction to the following scenario: Class Schedule Card: Data 100 Student list: 70000 pieces of data Student transcript SC: Data 70W Query purpose: Find candidates with 100 points in Chinese test Query statement: Execution time: 30248.271s Why […]

  • Alibaba cloud deployment 2.mysql

    Time:2019-10-20

    mysql download Directly use Yum to quickly build. wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10.noarch.rpm yum -y install mysql-community-server Start stop MySQL service start-up [[email protected] ~]# systemctl start mysqld.service Use PS – EF | grep Mysql to view and find that the MySQL service has been started. [[email protected] ~]# ps -ef | grep mysql […]

  • Mysql database basic operation command

    Time:2019-10-19

    Next: introduction to common commands for getting started with MySQL Today, I will introduce some basic commands for the operation of guantian MySQL database. Users and permissions Create user mysql>create user test identified by ‘[email protected]#’; Change Password 5.5 and previous commands mysql>set password for test=passowrd(‘[email protected]#3’); 5.6 and above mysql>update mysql.user set authentication_string=password(‘A1b2c3#[email protected]’) where user=’test’; Create […]

  • The best MySQL tool in MAC: sequel Pro extended (bundle) single line display tool

    Time:2019-10-19

    I’ve been looking for a better MySQL tool under Mac.Try a few:Navicat is really a cardTableplus is easy to use, but what’s more painful is the chargeSequel Pro was not easy to use at first, but now it’s more perfect and needs to be adjusted Go to the topic:1. Set the prompt delay of sequel […]

  • MySQL foundation may

    Time:2019-10-19

    1. Log in to MySQL mysql -uroot -p –prompt=\h~\ \c Delimiter // modify the default Terminator \T // output to log \t