NAV: SLTechnology News&Howtos > Database >

• 

  Common sentences in Mysqldump

  1: export a table structure and data of the database. / mysqldump-- opt-h 192.168.1.123-u root-p dbname table1 > / Users/1.sql-- opt here

  2022-06-01 12:02:47 Views: 231
• 

  Mongodb2.6 deployment replica set + Partition

  Deployment planning operating system: redhat6.4 64-bit ConfigRoute shard 1 shard 2 shard 3 using port 2800027017270182701927020IP address 192.168.1.30/etc/config.c

  2022-06-01 12:02:42 Views: 262
• 

  BI Publisher rtf template header footer

  Using BI,rtf templates for report development requires repeated display of fixed content on each page. The simplest solution is to put the contents of the entire rtf template into the table, and then set the header row to be displayed repeatedly. But for this kind of nested tables, it will be very messy and inconvenient to change. The second is to put the content on the header page.

  2022-06-01 12:02:42 Views: 201
• 

  NBU HPUNIX RAC reverts to HPUNIX stand-alone

  Note: the operating system environment of this document is mainly HPUX, and it is assumed that you want to restore the oracle RAC database on HPUX to a stand-alone machine. This document mainly focuses on database recovery, ignoring operating system installation, database installation and configuration, and NBU client installation configuration. Database information to be recovered:

  2022-06-01 12:02:42 Views: 280
• 

  The problem of empty string conversion value encountered in MS SQL

  The market capitalization of a column of varchars (30) named AX needs to be added to the numeric field, and there is an error "when converting from data type varchar to numeric" using select cast (AX as decimal (12L2)).

  2022-06-01 12:02:42 Views: 205
• 

  An example of oracle trigger, sequence and Task Planning exercise

  Today, I practiced the oracle task plan in my spare time. The details are as follows. Create table TBL_TIMEcreate table tbl_time (id number not null, / * id number * / vseco)

  2022-06-01 12:02:41 Views: 238
• 

  Source code installation and uninstallation of mysql

  Uninstall first, remove the old version of mysql related to one. Check to see if MySQL is installed on the server to see if the package is installed: rpm-qa | grep mysqlyum list mysql* removes the old version of mysql related software yum rem

  2022-06-01 12:02:41 Views: 224
• 

  PDB related statements

  Sys@newtestCDB > col restricted format A10sys@newtestCDB > col name format A20sys@newtestCDB > select v

  2022-06-01 12:02:41 Views: 211
• 

  Mysql-5.7.19 winx64 unzipped version installation configuration tutorial

  The mysql package file goes to the mysql official website to download https://dev.mysql.com/downloads/mysql/ to download the corresponding system and version number of the installation package. Here, download the windows64 bit zip package, decompress and install it.

  2022-06-01 12:02:11 Views: 242
• 

  Overview of SQL Server database

  SQL Server is a database management system that runs mainly through Windows services. This article mainly introduces how to perform the basic operation and management of the database to start or stop the database service. after completing the database installation, you need to manually check whether the installation is successful and whether it is in operation.

  2022-06-01 12:01:59 Views: 260
• 

  Install mysql in glibc mode

  Download the installation package mysql-5.6.38-linux-glibc2.12-x86_64.tar.gz to create the mysql user useradd-r mysql- s / sbin/nologin extract the file tar-z

  2022-06-01 12:01:59 Views: 273
• 

  Select count (*) from v$lock query is slow

  Description: select count (*) from v$lock query slow solution. For specific reasons, please see the official optimized document, ha SQL > set time on 00:51:52 SQL > select count (*) f.

  2022-06-01 12:01:58 Views: 281
• 

  Oracle database password file creation and make

  Oracle relational database system has been widely used because of its excellent performance, and ensuring database security is an important part of database management. On the basis of summarizing the security management of Oracle database, this paper focuses on the creation, use and

  2022-06-01 12:01:58 Views: 287
• 

  Dns,mariadb. Mail service

  # Auxiliary dns and its automatic synchronous encryption on the main dns side [root@localhost ~] # hostnamectl set-hostname dns-serverslave side

  2022-06-01 12:01:28 Views: 292
• 

  Stream exception results in continuous generation of trc files

  The production warehouse of a certain province received an alarm message oracle directory of 100%, and logged in to the system to check that the part-time job was mistakenly scrubbed. Mon Oct 23 23:25:18 EAT 2017Thread 1 advanced to log sequen

  2022-06-01 12:01:18 Views: 257
• 

  Mysql Advanced

  1 MySQL sql_modesql_mode is an easy to ignore variable, empty by default, can tolerate some illegal operations, in the production environment, it must be set to strict mode, it is also necessary to match this variable in the development test environment

  2022-06-01 12:01:18 Views: 206
• 

  Oracle stops running the timing method

  Oracle scheduled tasks: 1. DBMS_JOBS:dbms_jobs is just an instance of the jobs object, just as for tables, emp and dept are both instances of the table. You can use the view SELECT * FROM DBA_J

  2022-06-01 12:01:12 Views: 274
• 

  Oracle Study-Oracle 11g RAC failure (Failed to create or upgrade OLR)

  Oracle Study-- Oracle 11g RAC failure (Failed to create or upgrade OLR) system environment: operating system: RedHat EL5.5Cluster: Orac

  2022-06-01 12:01:12 Views: 307
• 

  [NoSQL] 01, NoSQL Foundation

  ACID, distributed, CAP, BASE theoretical relational databases follow ACID rules transaction in English is transaction, which is very similar to transactions in the real world, it has the following four characteristics: 1. A (Atomicity) atomicity is very atomic.

  2022-06-01 12:01:12 Views: 294
• 

  The method of full Archive of Oracle Database

  First, the problem affects that if the database archive does not set the archive deletion policy or the archive explosion leads to full archive space, the database will not be able to provide services or even shut down the database. Because shutting down the database will start to write the log, at this time the space is full and the log cannot be written, thus causing the database to fail to start. Business

  2022-06-01 12:01:12 Views: 259