Remember to use not null in MySQL, or you'll have to go!

Introduction: in the morning, I received a text message with the content of "Dear Hello, XXX". At that time, I smiled. It's a joke that programmers can Get. It shows that the program doesn't Get my name correctly from the database, and then formats the null value as null. To get back to business, the reason for this situation i ...

Added by cip6791 on Mon, 31 Jan 2022 09:35:08 +0200

Implementation of MySQL database Series Based on Mycat database and table

MySQL sub database and table can be realized through the middleware Mycat. This paper briefly introduces several partition strategies of Mycat, mode, range and hash, and tests and verifies them respectively 1. MySQL implements database and table splitting based on Mycat 1.1 principle of warehouse and table division Data sharding can be div ...

Added by geek_girl_2020 on Mon, 31 Jan 2022 07:08:38 +0200

Redis learning object

1. Introduction We can see that the main data structures used in redis include: simple string (SDS), linked list, dictionary, compressed list, integer set, etc. Redis objects are implemented by these data structures. Moreover, in order to select more appropriate data structures for different objects in different use scenarios, redis has cr ...

Added by brokeDUstudent on Mon, 31 Jan 2022 00:53:48 +0200

Thoughts caused by Android sensitive data disclosure

1. The whole story One cool afternoon, I saw a news that the interface was being mechanically called. I suspected that someone was using script to brush the interface (mainly to divert water from the platform). what? No, the general interface request is encrypted. Unless you know the encryption key and encryption method, the call will not ...

Added by iHack on Sun, 30 Jan 2022 23:01:34 +0200

Docker rapid deployment of mysql master-slave database

Master-slave database Install docker Please refer to my other article: https://blog.csdn.net/m0_46435741/article/details/121502952 Create a new instance of the main mysql container Create a container with mysql version 5.7. Mount data volume: Mount the configuration file to the host Directory: / mydata / MySQL master / conf Mount the log ...

Added by szym9341 on Sun, 30 Jan 2022 18:30:53 +0200

[prepare for autumn recruitment] interview of Linux operation and maintenance electronics factory

1. The database data is damaged due to misoperation of drop statement. Please write down the recovery idea and actual general steps? #The recovery of all data depends on backup. If there is no backup, it cannot be recovered In case of recovery after misoperation, the incremental recovery method shall be used for recovery. The specific steps ...

Added by beckjoh on Sun, 30 Jan 2022 16:27:23 +0200

Python big data processing library PySpark Practice II

Pyspark establishes Spark RDD Each RDD can be divided into multiple partitions. Each partition can be regarded as a data set fragment and can be saved to different nodes in the Spark clusterRDD itself has fault-tolerant mechanism and is a read-only data structure, which can only generate new RDD through transformation; An RDD can be proces ...

Added by pete07920 on Sun, 30 Jan 2022 16:23:19 +0200

Advanced notes on MySQL in Silicon Valley - Part 1

thank Thank you, Mr. Zhou Yang ❤️❤️ Station b video address Uninstall previous version View the installed MySQL RPM - qa|grep - I MySQL Uninstall mysql-community-server-5.6.36-2 one by one using Yum remove el7. x86_ sixty-four Installation of MySQL for Linux Download MySQL installation package wget https://dev.mysql.com/get/mysql57-comm ...

Added by mbariou on Sun, 30 Jan 2022 07:19:24 +0200

MySQL from getting started to deleting databases

0. General MySQL basic notes, review and useEnvironment construction: detailed installation steps of MySQL database nameexplaincommandDDL (data definition language)Define and manage data objects, such as databases, data tables, etccreate,drop,alterDML (data operation language)Used to manipulate data contained in database objectsinsert,update, ...

Added by amar3d on Sun, 30 Jan 2022 05:47:21 +0200

Get to know Redis-3-Redis cluster and advanced

Redis publish and subscribe Redis publish / subscribe (pub/sub) is a message communication mode: the sender (pub) sends messages and the subscriber (sub) receives messages Redis client can subscribe to any number of channels Subscribe / publish message diagram: The following figure shows the relationship between channel 1 and the thre ...

Added by DimeDropper on Sat, 29 Jan 2022 23:06:30 +0200