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