MySQL Learning Notes 3 - JDBC

Introduction to JDBC Java Database Connectivity (JDBC) is an application interface in the Java language that specifies how client programs access the database, providing methods such as querying and updating data in the database. Database Driver What is a database driver? Similar to sound card driver, graphics card driver Our programs ar ...

Posted by kc5tvd on Sun, 13 Feb 2022 20:11:53 +0100

Bloom filter [proposed by bloom in 1970; Redis cache penetration solution]

What is a bloom filter Bloom Filter was proposed by a young man named bloom in 1970. It has been 50 years since then. It is actually a very long binary vector and a series of random mapping functions. Everyone should know that the stored data is either 0 or 1, and the default is 0. It is mainly used to judge whether an element is in a set. 0 ...

Posted by arun_php on Sun, 13 Feb 2022 17:37:23 +0100

Installation and use of SQLite

In the previous article, we gave an overview of database knowledge:< Database overview >, this paper introduces some basic and commonly used SQLite database knowledge. SQLite Foundation SQL basic syntax insert INSERT INTO Table name (Column name 1,...) VALUES (Column 1 value,...); modify UPDATE Table name SET Column name 1= Colum ...

Posted by celestineweb on Sat, 12 Feb 2022 07:32:38 +0100

18000 word SQL optimization Daquan [reprinted from WeChat official account data analysis and statistical beauty]

Guide: many friends analyze data for two minutes and run for two hours? In the process of using SQL, we should not only pay attention to the data results, but also pay attention to the execution efficiency of SQL statements. This article involves three parts with a long length. It is suggested to read it after collection: SQL introductio ...

Posted by turansky on Sat, 12 Feb 2022 06:16:22 +0100

mysql5.7 master slave replication, mycat2 configuration, read-write separation

mysql5.7 master-slave synchronization, mycat2 configuration, read-write separation (windows) This article is referenced and reproduced from the article MySQL5. Master slave configuration,mycat2 fast build,mycat2 read write separation configuration , only used to record your learning process 1, Mysql5 7 configure master-slave synchronization ...

Posted by tom2oo8 on Sat, 12 Feb 2022 04:18:03 +0100

Java implements password adding random salt for MD5 digest encryption (2021 / 05 / 11)

Java implements password adding random salt for MD5 digest encryption (2021 / 05 / 11) 1. General In daily development, we often face the problem of saving the user password. We must not store the password in plaintext to the database. We can use hash digest algorithm to encrypt the password and then save it to the database. Hash digest ...

Posted by Begby on Sat, 12 Feb 2022 03:13:08 +0100

CentOS7 configuring network installation MySQL

In the process of online MySQL installation, since centos7 was used for the first time, it took a long time to record the successful configuration method. Modify yum source Enter the local machine to modify the yum configuration file Enter yum.com repos. D directory cd /etc/yum.repos.d/ Add the existing Yum source: / etc / yum repos ...

Posted by perrij3 on Sat, 12 Feb 2022 01:48:55 +0100

[tcallusdb knowledge base] restful API For generic table - [PB] ReplaceRecord introduce

[tcallusdb knowledge base] restfulapi2 0 for generic table - [Pb] replacerecord2 0 Introductionbrief introductionAdd a new record or replace the old one with a new one. If the record already exists, update it; If the record does not exist, insert a new record.POST http://{Tcaplus_REST_URL}Request syntaxHttp request#Tencent cloud console RESTful ...

Posted by jkohns on Fri, 11 Feb 2022 23:49:16 +0100

Redis common command notes

1, Common commands for keys keys * View all current key exists key Judge a key Does it exist type key View your key What type is it del key Delete the specified key data unlink key according to value Select non blocking delete to delete only keys from keyspace If the metadata is deleted, the real deletion will be carried out in subsequent asyn ...

Posted by vbzoom.com on Fri, 11 Feb 2022 22:06:07 +0100

[tcallusdb knowledge base] restful API For list table - [PB] [PB] ListDeleteRecord introduce

[tcallusdb knowledge base] restfulapi2 0 for list table - [Pb] listdeleterecord2 0 Introductionbrief introductionDelete the record of the specified subscript under the corresponding Key in the List PB table.Index: Specifies the subscript of the record to delete.POST http://{Tcaplus_REST_URL}Request syntaxHttp request#Tencent cloud console RESTf ...

Posted by php_joe on Fri, 11 Feb 2022 19:13:04 +0100