NAV: SLTechnology News&Howtos > Database >

• 

  Oracle subquery

  Recently, in strengthening the oracle query, I saw a good video on the Internet, sharing the learning notes with you about the syntax of the oracle subquery (that is, the nesting of select statements). Parentheses 2 in subquery syntax. Writing style of subqueries 3

  2022-06-01 11:14:22 Views: 285
• 

  Mysql creates a large number of disk temporary tables

  It is found that the temporary tables created in mysql are basically disk temporary tables, which can be checked. Finally, it explains the temporary table mechanism. By looking at the mysql status variable, you can see that the temporary tables created are basically disk temporary tables. View the temporary table configuration, the default configuration is 16m, and the configuration does not

  2022-06-01 11:14:22 Views: 256
• 

  Do ASM in oracle asmilb way

  1. Install rpmrpm-ivh kmod-oracleasm-2.0.6.rh2-2.el6.x86_64.rpm oracleasmlib-2.0.4-1.el6.x86_64.rpm oracl

  2022-06-01 11:14:22 Views: 278
• 

  MySQL initializes the installation

  Download the mysql compiled package and extract it to / export/local/ (depending on your usage). Next, add mysql users and user groups 1, groupadd mysql2, useradd-r-g mysql m

  2022-06-01 11:14:21 Views: 224
• 

  Centos 6.4x64 install mongodb

  Centos6.4 x64 simply installs MongoDB I, downloads MongoDB2.4.9 version and downloads MongoDBwget http://fastdl.mongodb.org/linux/mongodb-linux

  2022-06-01 11:14:21 Views: 229
• 

  Mysql master-slave replication GTID

  -installation preparation configuration / etc/my.cnf master master grant allocation replication account slave slave change; enable sl

  2022-06-01 11:14:21 Views: 290
• 

  Configure always on mode of SQL 2016 for SharePoint 2016 (1)

  In the previous article, I wrote some articles on the deployment configuration of SharePoint 2016, which was demonstrated in a test environment, using only one SQL Server 2016 as the back-end database storage server. In fact, in the daily production of enterprises

  2022-06-01 11:13:51 Views: 281
• 

  Mysqldump for mysql backup and recovery

  Mysqldump is the utility that mysql uses to transfer the database. It mainly produces a SQL script that contains mysqldump syntax such as CREATE TABLE INSERT, which is necessary to recreate the database from scratch: default configuration read

  2022-06-01 11:13:50 Views: 212
• 

  Compile and install LAMP based on CentOS6.7

  1. The required software download test machine environment is: Httpd2.4 download: http://mirrors.cnnic.cn/apache//httpd/httpd-2.4.25.tar.bz2Apr download: http://m

  2022-06-01 11:13:34 Views: 281
• 

  ORACLE SQL TUNING ADVISOR

  The main steps used by sql tunning advisor are as follows: 1 to establish tunning task2 to execute task3 to display tunning results 4 to run the corresponding tuning method according to the recommendation-ADVISOR authorization 1 based on

  2022-06-01 11:13:33 Views: 217
• 

  How to solve the problem of inconsistent characters in the target database when importing data by IMP in Oracle

  The IMP import and export functions of Oracle are often used in the production environment to achieve the purpose of data migration. The character set is usually queried in the source and target databases. The import IMP import error message in the test environment is as follows: import command: [oracle@l

  2022-06-01 11:13:33 Views: 237
• 

  Download MariaDB10.1.22 Spider3.3 Tencent patch sub-library and sub-table

  Since Tencent Tspider is not open source, I got the Spider3.3 source code of the original author Kentoku Shiba (integrated with Tencent patch for enhanced performance), and compiled it into the GA version of MariaDB 10.1.22, the binary download address.

  2022-06-01 11:13:21 Views: 203
• 

  MYSQL Learning Series-- DML sentences (2)

  Introduction: data manipulation language (Data Manipulation Language, DML) is a set of instructions responsible for running data access to database objects in SQL language, with INSERT, UPDATE and DELETE instructions as the core.

  2022-06-01 11:12:51 Views: 242
• 

  Zabbix Monitoring of stand-alone MongoDB

  Recently, the company has launched several new mongodb projects (stand-alone MongoDB), which need to sit down and monitor. There was a monitoring template before, but it didn't work well. So I went to google again and got the following record. Reference https://github. for stand-alone version

  2022-06-01 11:12:42 Views: 220
• 

  [Oracle Database] DataGuard (rac-single)

  [oracle@king01 ~] $sqlplus / as sysdbaSQL > alter database force logging;Database altered.SQL > col fo

  2022-06-01 11:12:32 Views: 290
• 

  Efficiency-SQL self-help query platform

  Use time: 2014-05-so far. Upgrade & change: no changes have been made after putting into operation, stocking status. Operation: used in internal environment, sharing DBA workload 500times per day + query. Birth background: number of DBA-3 DBA besides routine maintenance and data

  2022-06-01 11:12:32 Views: 253
• 

  Basics of getting started with Mysql

  Introduction to MySQL 1. What is a database? Database (Database) is a warehouse that organizes, stores and manages data according to data structure. It came into being more than 60 years ago. With the development of information technology and market, especially after the 1990s, data management is no longer just

  2022-06-01 11:12:32 Views: 257
• 

  Mysql user management under Linux, commonly used SQL statements, mysql database backup and recovery

  Notes: 13.4 mysql user management 13.5 commonly used mysql statements 13.6 mysql database backup recovery note date: 2017-10-3113.4 mysql user management when building a website, the background application will connect to mysql

  2022-06-01 11:12:02 Views: 212
• 

  The case of Oracle Study-- Oracle Sqlplus error

  Oracle Study case-Oracle Sqlplus error system environment: operating system: AIX5.3 database: Oracle 10gR2 case study: 1. View spatial information [oracle@aix220 ~] $df

  2022-06-01 11:11:56 Views: 219
• 

  The solution that there is no scott user in oracle database under Linux operating system

  ① logs in to the database as the 'sys' user, and type select * from dba_users; to see if the scott user exists, as shown in the following figure: as shown in the figure above, the scott user does not exist. ② because the operating system is Linux

  2022-06-01 11:11:46 Views: 298