NAV: SLTechnology News&Howtos > Database >

• 

  Device, find, and link

  # device # 1. Device identification / first serial hard disk in dev/sda # # system / first parallel hard disk in dev/hda # # system

  2022-06-01 14:49:10 Views: 259
• 

  Oracle Database Patchsets

  Patchsets12.1.0.2 (12.1.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) 2141922111.2.0.4 (11.2.0.4.0 PATC)

  2022-06-01 14:49:09 Views: 206
• 

  Sp_executesql

  Declare @ i1 int,@ i2 int,@Sql1 nvarchar (max) set @ Sql1 = N'select @ i1 = 1meme i2 = 2 'exec sp_execute

  2022-06-01 14:49:09 Views: 248
• 

  Oracle 12c command line to create PDB

  1. Log in to CDB to create pdbsqlplus / as sysdbacreate pluggable database pdb4admin user pdb4 identified by pdb4file_

  2022-06-01 14:49:09 Views: 277
• 

  One linux command per day (18): locate command

  Locate allows users to quickly search for specified files in the file system. The method is to first establish a database that includes all the file names and paths in the system, and then when looking for it, you only need to query the database without actually going deep into the file system. In the general di

  2022-06-01 14:49:09 Views: 227
• 

  Redis is the reason for single thread

  This article is to share with you about the reason why redis is single-threaded, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. An introduction to redis is a key-value memory

  2022-06-01 14:49:08 Views: 259
• 

  Skills of using MySql string function

  1. Intercept the string left (str, length) from the left. Description: left (intercepted field, intercepted length) example: select left (content,200) as abstract from my_conten

  2022-06-01 14:49:08 Views: 268
• 

  RHEL 6.4 install Oracle 11.2.0.1 R2

  Installation environment: RHEL 6.4 x86_64oracle 11.2.0.1 R2 system requirements: memory: > 1G swap space: generally twice the size of memory (memory size * 2) hard disk: more than 5G check command; memory # grep MenTotal

  2022-06-01 14:49:08 Views: 230
• 

  Redis-CentOS 6.5 installation Test of NoSQL

  1. To download redis, you can install or download redis ① online. Before you install online, you need to check whether there is a rpm package. If you do not exist, check whether the yum exists online. If the rpm package does not exist, you can only download it manually or by other means. [root@localhost

  2022-06-01 14:49:08 Views: 288
• 

  Trial time series database InfluxDB

  Hadoop cluster monitoring needs to use a time series database. Today, I spent half a day doing research and using the recently popular InfluxDB. I found that it was really good. Record your learning experience. Influx is written in GE language and is specially developed for time series data persistence.

  2022-06-01 14:49:05 Views: 255
• 

  Introduction to formatting function of mysql

  In this issue, the editor will bring you an introduction to the formatting function of mysql. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. Mysql format function: 1. DATE_FORMAT (date

  2022-06-01 14:49:05 Views: 213
• 

  Conditional Control statement in 8.PL_SQL--PL_SQL

  Like most program languages, PL/SQL also has the structure of controlling the execution of statements, which mainly includes: 1, sequential structure: the program executes statements one by one from top to bottom, that is, sequential structure; 2, branch condition judgment: branch condition judgment mainly refers to IF statement and CASE statement. 3. Loop statement:

  2022-06-01 14:49:05 Views: 230
• 

  The method of realizing pessimistic Lock in mysql

  In this issue, the editor will bring you the methods of realizing pessimistic lock in mysql. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. Introduce: pessimistic lock, as its name, has strong monopolistic and exclusive characteristics. It refers to

  2022-06-01 14:49:04 Views: 265
• 

  Form submits the form to the database

  Log in to angularJSPlease sign in < / h3 > Email addressPasswordRemeber meSign in

  2022-06-01 14:49:03 Views: 245
• 

  Introduction of functions commonly used in MySQL

  In this issue, the editor will bring you an introduction to the functions commonly used in MySQL. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. The MySQL function is an internal function provided by the MySQL database. These internal letters

  2022-06-01 14:49:03 Views: 217
• 

  What is the purpose of locks in mysql

  What is the purpose of locks in mysql? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. A lock is a machine in which a computer coordinates multiple processes or threads to access a resource concurrently

  2022-06-01 14:48:59 Views: 222
• 

  Introduction of encryption function of mysql Database

  This article uses easy-to-understand examples to introduce the encryption function of mysql database, the code is very detailed, interested friends can refer to, hope to be helpful to you. Mysql encryption functions are: 1. AES_ENCRYPT (str,key)

  2022-06-01 14:48:59 Views: 278
• 

  Some Analysis methods of mysql Lock

  When a lock or deadlock occurs in the database, it should be analyzed comprehensively, and the database should be analyzed with the database monitoring system and business at the same time to find problems. Here are some commonly used manual references: reference parameters: innodb_lock_wait_timeout View Yes

  2022-06-01 14:48:59 Views: 287
• 

  Vertical split in database

  In this issue, the editor will bring you an introduction to the vertical split in the database. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. The concept of vertical split is split according to the correlation of the data tables in the database.

  2022-06-01 14:48:58 Views: 248
• 

  What are the system information functions in mysql

  This article will explain in detail about the system information function in mysql, the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article. The system information in the system information function MySQL includes: the version of the database

  2022-06-01 14:48:58 Views: 302