NAV: SLTechnology News&Howtos > Database >

• 

  Sql numbering skills

  Beginfor i in 1.. 10000loopinsert into tcustmer values (I, 'xixixi','','aa'); end loop;commi

  2022-06-01 15:55:58 Views: 243
• 

  Install PHPStudy2016, open the port and see the port 80 PID4 process: System

  When installing phpstudy under windows7, port 80 was found to be occupied. Using the netstat-ano command, it is found that the system process PID4 occupies port 80. It's no use changing the registry and getting rid of IIS. It turned out to be SQL Server.

  2022-06-01 15:55:55 Views: 302
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (1)

  Technical background in SQL Server 2012 and 2014, the only way to initialize a secondary copy in an SQL Server Always On availability group is to use backup, replication, and restore. SQL Server 2016 citation

  2022-06-01 15:55:52 Views: 278
• 

  Linux system Oracle12.2 RAC cluster maintenance _ Oracle database 12cR2 (part 5 of the project)

  Course objective: Fengge Oracle Database course 12cR2 (Project practice Series): Oracle 12.2 RAC implementation and basic maintenance on Linux system, including system installation and environment configuration, ASM storage configuration, Oracle 12cR2 RAC

  2022-06-01 15:55:52 Views: 244
• 

  LAMP environment building + iTop installation (it is more convenient to use centos7 in practice)

  Centos 6.7basic server set up apache+mariadb+phpApache1 and ifup ifcfg eth0, and configure boot to start automatically; 2. Setup sets dns3 and yum insta

  2022-06-01 15:55:51 Views: 245
• 

  Introduction to pt (Percona Toolkit) tool

  Introduction of pt (Percona Toolkit) tool I. Introduction 1. Find examples of duplicate indexes and foreign key pt-duplicate-key-checker: [root@node1 ~] # pt-duplicate-key-

  2022-06-01 15:55:50 Views: 214
• 

  30 minutes getting started with Oracle sql statement

  SELECT * | {[DISTINCT] column | expression [alias],...} FROM table;SELECT * FROM departments twitt select dep

  2022-06-01 15:55:50 Views: 313
• 

  Detailed explanation of My.cnf database parameters

  / etc/my.cnf file is the configuration file of mysql. The details are as follows: [mysqld] / / server-side configuration datadir=/data/mysql / / data directory socket=/var/lib/mysql/mys

  2022-06-01 15:55:50 Views: 245
• 

  The RMAN of Oracle Learning (Fifteen) to restore the actual combat-- TSPITR

  TSPITR is the abbreviation of Tablespace Point In Time Recovery in English. That is, the table space is restored at a fixed time. TSPITR is a relatively fine-grained incomplete recovery technique. The restore operation we usually see is to put all the

  2022-06-01 15:55:50 Views: 227
• 

  Restart phenomenon of flip-flop of UPDATE type

  SQL_1 > create table mytest (id int); table has been created. SQL_1 > insert into mytest select 1 from dual; has created 1 line. Create

  2022-06-01 15:55:49 Views: 206
• 

  Percona MongoDB HotBackup Hot backup tool

  Percona MongoDB HotBackup hot backup tool preface: at present, the official MongoDB community version does not support HotBackup hot backup. We can only export bson files through logical backup tools such as mongodump, and then mo.

  2022-06-01 15:55:49 Views: 259
• 

  How to use SQL statement to view table structure

  How to use SQL statements to view the table structure? In view of this problem, this article gives the corresponding analysis and answers, hoping to help more friends who want to solve this problem to find a more simple and feasible way. The first step is to open the mysql command line editor. Step two, we enter the password and log in.

  2022-06-01 15:55:35 Views: 214
• 

  What are the main features of InnoDB

  What are the main features of InnoDB? In response to this problem, the editor summed up this article today, hoping to help more friends who want to solve this problem to find a more simple and feasible way. Since MySQL 5.1, the default storage engine has become InnoDB storage reference

  2022-06-01 15:55:35 Views: 279
• 

  The method of adding and unlocking by php and redis

  This article will explain in detail the methods of adding and unlocking php and redis. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. Business background: locks are needed in room board games to prevent concurrent operations.

  2022-06-01 15:55:32 Views: 220
• 

  Installation and simple use of redis

  As an example, redis is an in-memory database, a simple key-value structure, and a nosql database. Because the structure is simple and memory is used, the speed is very fast. As for the question, how fast? As we all know, the speed of the previous mechanical hard disk is actually quite good.

  2022-06-01 15:55:32 Views: 275
• 

  How to add redis Custom commands

  This article will explain in detail how to add redis custom commands, the content of the article is of high quality, so share it with you for reference. I hope you can get something after reading this article. Redis has become a standard cache for Internet companies because of its high performance and light weight.

  2022-06-01 15:55:29 Views: 241
• 

  The data models in the database can be divided into several types

  How many data models can be divided into databases? Perhaps many people do not understand, in order to let you understand better, the editor summed up the following content, I hope you can gain something according to this article. According to the organizational form of the data, the data model can be divided into hierarchical model, mesh model and relational model. Layer

  2022-06-01 15:55:28 Views: 260
• 

  What exactly does a relationship in a relational database mean?

  What exactly does a relationship in a relational database mean? In view of this problem, this article gives the corresponding analysis and answers, hoping to help more friends who want to solve this problem to find a more simple and feasible way. The so-called relationship in the relational database management system means that the data model satisfies certain conditions.

  2022-06-01 15:55:28 Views: 270
• 

  How to integrate Redis cache with SpringBoot

  How does SpringBoot integrate Redis cache? In response to this problem, the editor summed up this article today, hoping to help more friends who want to solve this problem to find a more simple and feasible way. 1. Introduce cache dependency org.springframewo

  2022-06-01 15:55:28 Views: 231
• 

  Zabbix server3.0 is installed on centos 7 (monitoring native)

  Preparation before installation: 1.1 install dependency package: yum-y install wget net-snmp-devel OpenIPMI-devel httpd openssl-devel java lrzsz fpi

  2022-06-01 15:55:21 Views: 267