NAV: SLTechnology News&Howtos > Database >

• 

  Easy installation of zabbix

  Close selinux: vi / etc/selinux/configSELINUX=disabled first add an official yum source of zabbix rpm-ivh http://repo.zabbix.com/z

  2022-06-01 12:20:02 Views: 201
• 

  Character class function of Oracle

  1JINITCAP (C1) this function capitalizes the first letter of each word in C1 and returns the other letters in lower case. Select initcap (ename) from emp;2, LENGTH (C1) this function returns the length of C1. S

  2022-06-01 12:20:02 Views: 226
• 

  Sql injects piecemeal knowledge

  1. Order by explanation: in order by language, the query results can be sorted by adding the field name after the SQL statement. But he has a special usage, that is, the way to add numbers instead of field names. When you add a number, it indicates the number of fields in the table.

  2022-06-01 12:19:59 Views: 233
• 

  SQL Server 2012 configure Always On availability group

  Introduction to AlwaysOn AlwaysOn availability group is a new feature provided in SQL Server 2012, which ensures the availability of application data and achieves zero data loss. AlwaysOn availability group technology combines database clustering and database mirroring

  2022-06-01 12:19:29 Views: 279
• 

  MySQL forgot his password and could not log in.

  1. Edit the mysql configuration file my.ini (under the installation directory of mysql, mine is in D:\ Program Files\ MySQL\ MySQL Server 5.0\ my.ini) and add it under the entry [mysqld].

  2022-06-01 12:19:29 Views: 253
• 

  Db2 parameter view

  Db2 parameter view 1, view all existing DB2 profile registries db2set-lr2, view all set DB2 profile registries db2set-all3, set DB2 profile registry db2set DB2COMM=

  2022-06-01 12:19:22 Views: 294
• 

  MySQL show processlist description

  The output of the show processlist and show full processlistprocesslist commands shows which threads are running, and you can see not only the current number of connections, but also the current connection status to help identify

  2022-06-01 12:19:22 Views: 296
• 

  Sqlplus command learning

  Sqlplus command learn $sqlplus / as sysdbaSQL > help index you can enter the sqlplus command Enter Help [topic] for help.@ COPY PA

  2022-06-01 12:19:22 Views: 243
• 

  Redis hash type

  The key value of the hash type (hash) is also a dictionary structure that stores the mapping of the field (field) and the field value, but the field value can only be a string and does not support other data types, in other words, the hash type cannot nest other data types. A hash type key can contain up to 2

  2022-06-01 12:19:22 Views: 235
• 

  What are the locks of redis?

  In this issue, the editor will bring you what kinds of redis locks there are. 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 subtables of redis locking commands that can be used by redis are INCR, S

  2022-06-01 12:19:09 Views: 274
• 

  Use of MongoDB to database

  The use of MongoDB to database? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. Today's topic is to talk about databases from MongoDB. In daily projects, we

  2022-06-01 12:19:09 Views: 263
• 

  Sqli labs study notes

  Lesson01: character injection address bar plus? id=5' and'1 injection address bar test through address bar plus? id=5' (malicious sql statement can be added here)-- + test pass (annotated method) Lesson02: numeric injection id

  2022-06-01 12:19:09 Views: 229
• 

  Oracle 11g database startup and shutdown

  The startup status of the Oracles11 database Oracle11g must go through three states when it starts: NOMOUNT,MOUNT,OPEN. NOMOUNT: only open the database instance and read the parameter file in this state. MOUNT: based on parameter

  2022-06-01 12:19:08 Views: 238
• 

  The platform tree part gets or sets horizontal / vertical gridlines

  Gets or sets the horizontal gridlines: gets or sets whether to display the horizontal gridlines of the tree widget. True indicates that gridlines are displayed and false indicates that gridlines are not displayed. Gets or sets vertical gridlines: gets or sets whether the vertical gridlines of the tree widget are displayed. True indicates that gridlines are displayed

  2022-06-01 12:19:04 Views: 214
• 

  Solve the problem of oracle reporting Environment variable ORACLE_UNQNAME not d

  Solve the oracle report Environment variable ORACLE_UNQNAME not defined to reconfigure em, and the Oracle_SID environment variable must be set. 1. Modify DBSNMP secret

  2022-06-01 12:19:03 Views: 298
• 

  Chapter VI configuration and Management of Monitoring items

  Chapter VI configuration and management of monitoring items the definition and management of monitoring items (Items) in the Zabbix system is very important. All monitoring indicators collect data by defining different monitoring items. Zabbix organizes and manages monitoring items through the host as a logical unit, and all monitoring items are

  2022-06-01 12:18:47 Views: 298
• 

  Shrink tablespace files and save disk

  In the system I am in charge of, the database disk is often only about 20 gigabytes. In the past, the logs in the database server were deleted. After the logs were cleaned regularly, it was found that the table space was often insufficient. Every time, the problem is solved by expanding the table space, but after several times, the magnetism of the server is added.

  2022-06-01 12:18:46 Views: 226
• 

  DB2 performance Optimization-how to improve SQL query efficiency through db2 Optimization tools

  As we all know, after the application system is running for a period of time, users report that the system runs slowly, so that they cannot complete all the work, it takes too long to complete transactions and queries, or the application slows down at certain times of the day. In order to determine the essential cause of the problem, it is necessary to evaluate the reality of the system resources.

  2022-06-01 12:18:46 Views: 221
• 

  CentOS 7 installs Owncloud 9.1.3

  First of all, after installing the CentOS system, the installation of the system will not be introduced here. After the installation, the IP address # vi / etc/sysconfig/network-scripts/ifcfg-eth0BOOTPROTO= "sta is configured first.

  2022-06-01 12:18:44 Views: 294
• 

  How to encrypt tables in sql

  This article uses easy-to-understand examples to introduce how to encrypt the table in sql, the code is very detailed, interested friends can refer to, I hope it can be helpful to you. Sql encrypts the table by first testing the environment and then creating the database master key, then creating the certificate and creating the

  2022-06-01 12:18:21 Views: 227