NAV: SLTechnology News&Howtos > Database >

• 

  Establishing SSL connection without server's ident

  Exception information: Establishing SSL connection without server's identity verification is not recommended. Accordin

  2022-06-01 16:26:31 Views: 248
• 

  How SQL Server clears all table data in a database

  1. Clear all table data in SQL Server database (1) write stored procedure script: CREATE PROCEDURE sp_DeleteAllDataASEXEC sp_MSForEachTable 'ALTER

  2022-06-01 16:26:31 Views: 205
• 

  5m of mysql series-full backup and incremental backup

  First, the use of the system's own tools to achieve complete backup: mysqldump data backup mode: physical backup: directly copy the corresponding files of the library or table. Limited to myisam, cross-platform poor logic backup: when performing a backup, the corresponding sql command is generated according to the existing data, and the sql

  2022-06-01 16:26:31 Views: 242
• 

  Ssh password-less connection

  Key-based connection: to log in to a remote host without entering a password, the public key (Public Key) and private key (Private Key) relative to the user-- a key pair obtained through an encryption algorithm-- the public key is the public part of the key pair. The public key is owned by me.

  2022-06-01 16:26:31 Views: 216
• 

  MySQL5.6.25 upgrade MySQL5.7.15

  MySQL5.6 upgrade MySQL5.7 environment introduction Part1: written in the first mention of MySQL upgrade, there are countless online articles, but most of them are old versions, such as 5.1 to 5.5,5.5 to 5.6. today, I would like to introduce you to MySQL5.6.

  2022-06-01 16:26:29 Views: 289
• 

  The case of Oracle Study-- BITMAP under Oracle ASSM Management

  The case of Oracle Study-- Bitmap under Oracle ASSM Management. Based on this, Oracle recommends that we use ASSM (Automatic) under LMT (Extent Local Management)

  2022-06-01 16:26:28 Views: 207
• 

  [fault handling] alarm log report "ORA-01565 Unable To open Spfile"

  [fault handling] alarm log report "ORA-01565 Unable To open Spfile" 1.1 BLOG document structure Diagram 1.2 Fault Analysis and Resolution process 1.2.1 Fault Environment introduction Project source dbdb Type R

  2022-06-01 16:26:16 Views: 299
• 

  SQL Server timeout diagnosis

  Connection timeout for connection timeout, you can first check the LoginTimers type error in Connectivity Ring Buffer to analyze, and then use the packet grabbing tool network monitor if you want to get more detailed information. Specific side

  2022-06-01 16:26:16 Views: 241
• 

  Import and export of mysql data table structure

  The specific usage under the command line to export mysqldump-h localhost-u root-p-P-d dbname > db.sql is as follows: mysqldump-h remote-u uses alias-p password-P side

  2022-06-01 16:26:16 Views: 290
• 

  SQL Server Alwayson build III: SQL server configuration

  Install .NET Framework 3.5/4.0IP configuration sql01sql02 install SQL Server 2014, select mixed authentication mode, set sa password server to add domain, and select restart server to use dcadmin login service after success

  2022-06-01 16:25:49 Views: 204
• 

  Install mongodb on rhel6

  Download: mongodb-linux-x86_64-3.2.6.tgz, please go to mongodb's official website to download, this address is not available for download. Upload mongodb-linux-x86_64-3.2.6.tgz to / usr/loc

  2022-06-01 16:25:48 Views: 248
• 

  Mongodb replicates remote and local databases db.copyData

  I also want to directly copy each other between mysqldbcopy and oracle 12c pdb. Copying, migrating data and preparing to develop a test environment will be addictive. Today, I have to migrate and prepare multiple sets of mongodb databases for production and test use. It is found that mongodb also has

  2022-06-01 16:25:48 Views: 268
• 

  Example of Oracle 10g RAC modifying IP/VIP address

  First, the preparatory work 1. Database information operating system version: OEL5.4 x64 database version: Oracle 10.2.0.5 x64 RAC2. IP address description: the server host name cannot be changed. If you really want to change the name, you need to repeat it.

  2022-06-01 16:25:48 Views: 253
• 

  Oracle building

  Introduction: Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It is a leading product in the field of database. It can be said that the Oracle database system is currently

  2022-06-01 16:25:27 Views: 255
• 

  Execution plan related to B-tree index

  Index unique scan, index range scan, index full scan, index fast full scan and index skip scan. Index unique scan: SQL > create table employee (gender varchar2 (1), employee_id

  2022-06-01 16:25:23 Views: 248
• 

  Senior Software engineer (interview questions)

  The following interview questions for senior software engineers, regardless of language, are applicable to all programming languages and are more biased towards design. Design a classification function for administrative division, commodity classification, etc., such as China-> Guangdong-Shenzhen. Requirements: infinite pole classification, unlimited hierarchical depth for fast retrieval, no

  2022-06-01 16:25:23 Views: 257
• 

  Update of MongoDB documents (1)

  MongoDB document update: 1. Can be to delete the original document and then insert an updated new document into the database; 2. Use modifiers to modify document properties in the original document based on the original document. The main description below is to modify the text using the update method combined with modifiers based on the original document

  2022-06-01 16:25:23 Views: 269
• 

  Master-Slave replication of MySQL and its principle

  1. Master-slave replication configuration a. Environment: CentOS7.4,IP address is the master library: 192.168.11.146, slave library: 192.168.11.238, the master database version should be lower than or equal to the slave library version, here all use MySQL 8.0.13

  2022-06-01 16:25:23 Views: 301
• 

  Oracle11g installation process

  Install oracle software 1 > create user groups, users and directories under the bjdb node: [root@node1 /] # groupadd-g 200 oinstall [root@node1 /] # groupadd-g 2

  2022-06-01 16:25:22 Views: 273
• 

  Row-column conversion _ wmsys.wm_concat

  Requirement description loc_sys_busi_strategy is a vertical table, which needs to be converted into a horizontal table to facilitate Redis QUEUE processing. Source data format requirements format note where speed,area is the title heading in the requirement format. Format conversion selec

  2022-06-01 16:25:21 Views: 260