NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11g spaced Partition (INTERVAL) batch specification naming

  Friendly reminder: please operate when the business is free. Why? -- Oracle 11g partition (INTERVAL) rename, batch generate rename partition script set linesize 180set serverout ondec

  2022-06-01 11:50:15 Views: 276
• 

  A collection of common Mysql commands

  1. Count the number of rows of tables in the specified database: use information_schema;select table_name,table_rows from tables where TABLE_SCHEMA =

  2022-06-01 11:50:11 Views: 269
• 

  MySQL partition table explores the details of "tidying up from official files"

  MysqlPartition topic study1. Date Time partition When partitioning by KEY or LINEAR KEY, youcan use a DATE, T

  2022-06-01 11:50:11 Views: 294
• 

  PostgreSQL Master Slave upgrade process

  1. Initial state: Master,slave is in running state. two。 Upgrade process Master1). Close the last checkpoint location (latest checkpoint location) of the master record, which is during downtime

  2022-06-01 11:49:57 Views: 226
• 

  Oracle overview of Oracle topic 1, architecture of Oracle database, and common commands

  1. Oracle Overview-Oracle Database, referred to as Oracle for short. Is an object-relational database management system (ORDBMS) of ORACLE (Oracle) in the United States. At present, it occupies a major share in the database market. -Ora

  2022-06-01 11:49:57 Views: 265
• 

  Automatic backup of mysql database scripts

  Automatic backup of mysql database script #! / bin/sh# NCONF database backup# Script by Chen# add (and adapt) the following line t

  2022-06-01 11:49:57 Views: 210
• 

  Fill in the serial number in the specified field after SQL sorting

  1. Display the row number if the data is not deleted, the primary key and the row number are the same, but when some data is deleted, the row number is not consistent with the primary key, so you need to use a new method to query the line number. Before SQL Server2005, you need to use a temporary table, but in SQL Ser

  2022-06-01 11:49:47 Views: 272
• 

  The start-up and shutdown principle of oracle-the start-up phase of oracle

  Case 1: how to know which stage the current database is in? SQL > select instance_name,status from vastness instance STATUS-

  2022-06-01 11:49:32 Views: 226
• 

  Record an erroneous deletion of specified data from the database-& the lesson of gt; blood

  I was going to query select, but accidentally executed the command of delete, resulting in all the data of unitID=100004 being deleted. This is embarrassing. This is an online database. Check the binlog log quickly and expect to recover the number of lucky companies.

  2022-06-01 11:49:32 Views: 265
• 

  Jdbc link database (including connection pooling)

  / * * Copyright 2000-2020 YGSoft.Inc All Rights Reserved.*/package com.ygsoft.gris.mapp.materialmanage

  2022-06-01 11:49:31 Views: 238
• 

  Oracle Study-- Oracle 11gR2 RAC crs startup failure (CRS-4000)

  Oracle Study-- Oracle 11gR2 RAC crs boot failure (CRS-4000) system environment: operating system: RedHat EL5Cluster: Oracle 11gR2 GridOracl

  2022-06-01 11:49:01 Views: 289
• 

  The whole process of online examination system migration from Windows system to Linux system

  Original operating environment: operating system: Windows Server 2003 database system: MySQL Server 5.0Web server software: Apache2 programming language: PHP current running environment: operating system: CentOS releas

  2022-06-01 11:49:01 Views: 248
• 

  Essential for SQLserver operation and maintenance: introduction to T-SQL statement

  Http://xsboke.blog.51cto.com-------: thank you for your reference. If you have any questions, you are welcome to communicate. 1. The T-SQL language consists of three main languages: 1. DML: data manipulation language (data)

  2022-06-01 11:49:01 Views: 224
• 

  The first use of exp/imp in oracle Database

  Recently, when using oracle9i, I have encountered problems with database backup and recovery, which are often related to the use of exp and imp commands. In view of the problems encountered, a simple summary. The background of the problem is that you need to import and export a table. Database database1,date

  2022-06-01 11:49:01 Views: 215
• 

  Deploy redis master-slave cluster and turn on Sentinel mode

  1. Deployment environment system: centos7 completes the deployment of the master-slave cluster by launching two different redis instances on the Linux system. 2. Download and installation of redis 1. Download: official website download 2, installation creation / app/ directory, redis security

  2022-06-01 11:49:00 Views: 215
• 

  [python Learning] python connection database instance

  Method 1 for python to connect to MySQL, MongoDB, Redis, memcache and other databases. Python operation MySQL: for more information, please see [apt-get install python-mysqldb] code such as

  2022-06-01 11:49:00 Views: 207
• 

  Backup / restore of MySQL database by xtrabackup

  Http://hongge.blog.51cto.com/ uses xtrabackup for MySQL database backup. Previously introduced that mysqldump backup method is logical backup, its biggest defect is that backup and recovery speed are slow, for a

  2022-06-01 11:48:53 Views: 299
• 

  Index of MongoDB

  1, brief introduction it is like a book catalog, without it, we need to search the whole book to get the results we need, that is, the so-called full scan; and with the catalog (index), we can help us locate the target location and quickly get the results we want. 2. Acting

  2022-06-01 11:48:47 Views: 232
• 

  The structure of Bao Ding Jie Niu Database system

  Title index retrospective reason software structure file classification summary analysis retrospective reason mentioned that the data system is comparable, difficult to rise, thinking for a long time: "the reason why you can't know the true face of Lushan Mountain is because you are in the middle of this mountain." if you look at this mountain, you may be able to see the majestic appearance of that mountain. In order to know the database mountain, you can see the magnificence and true appearance of that mountain.

  2022-06-01 11:48:44 Views: 217
• 

  The blackmail virus colin_farel is found in the SQL Server database mdf file. The extension becomes colin_far

  The blackmail virus colin_farel is found in the SQL Server database mdf file. The extension changes to colin_farelSQL, database, blackmail virus, mdf file poisoning, colin_farel@aol.comSQL Serv

  2022-06-01 11:48:40 Views: 207