NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to the new features of Navicat Premium 15

  This article will explain in detail the introduction of the new features of Navicat Premium 15. The content of the article is of high quality, so I hope you can get something after reading this article. Navicat Premium is a database

  2022-06-01 17:01:54 Views: 254
• 

  Experiments related to mariadb transaction isolation level

  The SQL standard for isolation levels for SQL defines four types of isolation levels, as follows: 1. Read Uncommitted (read uncommitted) at this isolation level, all transactions can see the execution results of other uncommitted transactions. This isolation level is rarely used in practice.

  2022-06-01 17:01:53 Views: 254
• 

  Complete backup and recovery of mysql database commands

  Data full backup mysqldump-uroot-pabc123-- databases school > / opt/school.sql deletion library mysql > drop database school; lookup

  2022-06-01 17:01:53 Views: 206
• 

  Introduction to the decryption process of SQL SERVER SP

  This article will explain the decryption process of SQL SERVER SP for you in detail. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article. In SQL SERVER, Microsoft is known to be encrypting and decrypting storage

  2022-06-01 17:01:52 Views: 291
• 

  Execute mysql commands without logging in to the database

  1. Implement (this is relatively common) echo "show databases;" through echo | mysql-uroot-pqwe123-S / data/3307/mysql.sock hint: this method is suitable for single-line characters.

  2022-06-01 17:01:52 Views: 291
• 

  Scp remote backup

  Scp remote backup A host 1. Log in with oracle: 192.17.28.52. Generate public and private accounts: id_rsa is private, id_rsa.pub is public cd / home/oracle/.ssh-make sure that .ssh files are protected

  2022-06-01 17:01:52 Views: 286
• 

  Oracle database 19c install on LINUX 6.X

  The official 18C can also be installed at more than 6.4, but 19c now out of the exadata suddenly to 7.4 (official requirements), then 6.X can still be installed? After testing, the following ways are the most feasible, there are other better ways welcome to leave a message, (the following is purely a personal hobby, important production ring

  2022-06-01 17:01:52 Views: 219
• 

  The causes and Solutions of the failure of data Update in Mysql Database

  This article will explain in detail the reasons and solutions for the invalidation of data update in Mysql database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article. 1. Background A problem was encountered in the most recent project and sent an update

  2022-06-01 17:01:52 Views: 209
• 

  Oracle backup and recovery 1-database data and text files

  0. Catalog 1. Overview 2. Generate text file 2.1 query statement generate text file 2.2 spool export database data to text file 2.2.1 syntax 2.2.2 set sqlplus variable 2.2.3 DIY export data template 2.3 wind

  2022-06-01 17:01:51 Views: 299
• 

  New feature of MySQL 8.0-- CTE Recurive (2)

  The previous article introduced the basic usage of CTE, refer to the new feature of MySQL 8.0-CTE (1), and this article will introduce CTE Recurive recursion. 1. What is CTE Recurive?A recursive common ta

  2022-06-01 17:01:51 Views: 256
• 

  Several commonly used commands of Super practical MSSQL

  Query: select * from table name select * from table name where condition select * from Table 1, Table 2 where Table 1 field = Table 2 field [and condition 2...] selec

  2022-06-01 17:01:51 Views: 296
• 

  Introduction and use of T-SQL query sentence in SQL Server

  This article will introduce in detail the introduction and use of T-SQL query sentences in SQL Server. The detailed steps are clear and the details are handled properly. I hope you can get something through this article. Let's first take a look at the relevant terms and concepts of the article: first, the introduction of SQL in data management.

  2022-06-01 17:01:50 Views: 268
• 

  Restore using XtraBackup | backup Mysql database-data recovery section

  Data recovery part XtraBackup tool introduction: now we often take into account the growth of the amount of data when we backup MySQL. When the amount of data is small, use mysqldump, as the amount of data becomes larger and larger, mysqldump is not suitable. First, increase is not supported.

  2022-06-01 17:01:46 Views: 281
• 

  Installation and configuration of mongodb

  Conceptual MongoDB is a database based on distributed file storage. Written in C++ language. Designed to provide scalable high-performance data storage solutions for WEB applications. MongoDB is a product between relational database and non-relational database, which is one of non-relational databases.

  2022-06-01 17:01:46 Views: 281
• 

  Mysql lock (the difference between S lock and X lock)

  Shared lock and exclusive lock Mysql lock system: shared lock and exclusive lock (shared and exclusive locks, also known as read and write locks, that is, read lock and write lock) read locks are shared, or mutually unhindered

  2022-06-01 17:01:16 Views: 282
• 

  Openstack (2) detailed explanation of openstack components

  Xiaosheng blog: http://xsboke.blog.51cto.com------- thank you for your reference, if you have any questions, welcome to exchange directory: 1. Keystone details-(openstack certification)

  2022-06-01 17:01:16 Views: 296
• 

  How to change oracle to Archive Mode

  Archiving: the redo log is archived and rewritten to the new redo log file. The process of log switching is called log swith, and checkpoints are generated during the switch. All the data prior to the checkpoint has been archived. There are at least two redo log groups in the oracle database: SQ

  2022-06-01 17:01:15 Views: 238
• 

  [MySQL] Database performance testing tool-- HammerDB

  [root@wallet01 ~] # mysql-uroot-pabcd.1234mysql > create database tpcc;Query OK, 1 row affected (0.0

  2022-06-01 17:00:45 Views: 209
• 

  MapReduce imports text data into HBase

  Overall description: import the data from local files into hbase to create a table data format in HBase, MapReduce program, map program, package com.hadoop.mapreduce.test.map;import.

  2022-06-01 17:00:37 Views: 246
• 

  Mongodb monitoring script

  The script covers two ways to monitor mongo: using the built-in mongostat tool to view, the location of each monitoring item may have to be adjusted according to the actual mongostat output; and entering the admin library to view specific status information may need to be verified. Complete steps: 1. Chuang

  2022-06-01 17:00:36 Views: 221