NAV: SLTechnology News&Howtos > Database >

• 

  Linux installs SQL Server 2017

  Be forced to be helpless. I need to install SQL Server... under Linux The school should learn SQL Server.... Never install this tumor on your Windows, even if you uninstall it, it will contaminate the registry. At this time, the almighty VMware W

  2022-06-01 15:00:30 Views: 213
• 

  Access SQL Server WMI object

  Access the SQL Server WMI object 1. Use Powershell to access get-wmiobject-list-namespace "root\ Microsoft\ SqlServer" get-wmio

  2022-06-01 15:00:23 Views: 263
• 

  Insert data into the table when creating the table

  DECLAREBEGINexecute immediate 'create table TJ_JKTJBACK (tjbh VARCHAR2) not null,grbh VARCHAR2 (20

  2022-06-01 15:00:23 Views: 229
• 

  Database name, instance name, database domain name, global database name, service name

  Database name, instance name, database domain name, global database name, and service name are several concepts that are easy to confuse for many beginners. I believe that many beginners are as confused as I am by these concepts in the title. Let's figure them out now. 1 what is the database name?

  2022-06-01 15:00:22 Views: 225
• 

  Oracle 11g rac listener offline

  The oracle 11g rac listener appears the listening process offline after adjusting the network, and frequently switches between the two nodes. Check the log / var/log/message and find that there are frequent registration revocation actions. Monitoring log / u01/app

  2022-06-01 15:00:22 Views: 217
• 

  The usage of inner join in Database

  This article shows you the use of inner join in the database, the code is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. INNER JOIN returns when there is at least one match in the table.

  2022-06-01 15:00:22 Views: 272
• 

  Is there any difference between B-Tree and Hash in MySQL?

  Is there any difference between B-Tree index and Hash index 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. B-Tre in MySQL

  2022-06-01 15:00:20 Views: 229
• 

  Taobao open source tool: Orztop

  Mysql automated operation and maintenance tools reference documentation; Taobao open source tools: Orztop real-time view of the current processlist and full processlist; can view the real-time operation of mysql database sql status tools, previously suffered from the sh

  2022-06-01 15:00:20 Views: 292
• 

  What is a Redis transaction?

  Today, I would like to talk to you about the affairs in Redis, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. What is a redis transaction? Redis transactions can be executed more than once.

  2022-06-01 15:00:19 Views: 218
• 

  What are the memory obsolescence mechanisms in redis

  This article will explain in detail about the memory elimination mechanism in redis. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article. Redis memory obsolescence means that some of the keys stored by the user can be used by R.

  2022-06-01 15:00:19 Views: 215
• 

  How to deal with the expiration policy of redis

  How to deal with the expiration policy of redis? 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. You can set the data pass through the EXPIRE key seconds command

  2022-06-01 15:00:19 Views: 238
• 

  Collation of knowledge points in database 1

  First, the basic conceptual relational database: using two-dimensional tables to save data. The relational model consists of three parts: relational data structure, relational operation set and relational integrity constraints. Entity: something that exists objectively and can be distinguished in the real world. For example, "a student", "a book", "a course" and so on.

  2022-06-01 15:00:18 Views: 293
• 

  What are the paradigms of relational databases

  What are the paradigms of relational databases? 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. Normalization is required to identify data elements, relationships, and definitions in the database.

  2022-06-01 15:00:17 Views: 235
• 

  What is AOF persistence in redis

  What is AOF persistence in redis? 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. AOF persistence is also an important hand in Redis persistence.

  2022-06-01 15:00:14 Views: 287
• 

  SQL introduction Classic (5th Edition) Learning Notes (1)

  1. What is the meaning of the abbreviation "SQL"? What are the six main categories of stuctured query language structured query language 2.SQL commands? Transaction Control Command commit data definition language create table

  2022-06-01 15:00:14 Views: 223
• 

  What are the characteristics of Redis

  What are the characteristics of Redis? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. Redis is the most popular NoSQL (Not Onl) in the Internet world.

  2022-06-01 15:00:14 Views: 300
• 

  What are the basic principles of database design

  What are the basic principles of database design? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. The basic principles of database design: (1) to store data with the same topic in a

  2022-06-01 15:00:13 Views: 294
• 

  How to use right join in SQL statement

  How to use right join in SQL statement? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. Right join is a query type in the SQL language

  2022-06-01 15:00:10 Views: 211
• 

  The use of left join keyword in mysql

  This article is to share with you about the use of the left join keyword in mysql, 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. Left join key

  2022-06-01 15:00:10 Views: 277
• 

  What is the lock level of mysql

  Today, I will talk to you about the lock level of mysql. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. Lock level is what we usually call lock granularity. The type of lock is divided into read lock and write lock.

  2022-06-01 15:00:10 Views: 289