NAV: SLTechnology News&Howtos > Database >

• 

  Problem resolution of mongoDB startup failure

  System: centOS 5.5View Log: [root@localhost mongo] # tail-20 / usr/local/mongo/mongodb.logMon Sep 19

  2022-06-01 17:03:31 Views: 267
• 

  Mysql creates the database from the command line

  1. Syntax: CREATE DATABASE IF NOT EXISTS database name DEFAULT CHARSET default code set COLLATE proofreading rule 2. Syntax parsing: IF NOT EXISTS: if this number

  2022-06-01 17:03:31 Views: 230
• 

  Oracle12C cannot open em to http under https

  Sys@jyCDB > exec dbms_xdb_config.sethttpsport (0); PL/SQL procedure successfully completed.Elapsed: 00:

  2022-06-01 17:03:31 Views: 221
• 

  Redhat 7.x extension / dev/shm

  CLSRSC-184: Configuration of ASM failedCLSRSC-258: Failed to configure and start ASM [root@rac01 ~] #

  2022-06-01 17:03:30 Views: 202
• 

  Mysql common operators and functions

  1. Commonly used arithmetic operators 1.1operator, function, Note 1.2Note    (1) Integer (bigint) and Integer Operation (+, -,) the result is bigint;    (2) floating-point number and floating-point number operation (/), and the result is one of the decimal places participating in the operation.

  2022-06-01 17:03:19 Views: 274
• 

  Mode selection and Construction of Cloud data Warehouse

  The importance of data to an enterprise is self-evident. How to make good use of internal data and give full play to the greater value of data is particularly important for enterprise managers. As one of the most traditional data applications, data warehouse plays an important role in the enterprise.

  2022-06-01 17:02:52 Views: 235
• 

  Detailed explanation of redis info Information A

  # Serverredis_version:2.8.19 # redis version number redis_git_sha1:00000000 # git SHA1redis_git_dirty:0 # # git

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

  [reading notes] ORACLE11GR2 DataGuard architecture

  1. Data Guard Architecture Diagram 1.1 Data Guard Architecture Diagram Data Guard (hereinafter referred to as DG) consists of five parts, namely, redo data service, role management and switching, application service of standby library, protection mode of main library, and management of DG.

  2022-06-01 17:02:43 Views: 247
• 

  Advanced MySQL Database (2)-- Custom function

  MySQL Database Advanced (II)-- Custom function I. introduction to Custom function Custom function (user-defined function UDF) is a way to extend MySQL and its usage is the same as that of built-in function. Two necessary conditions for custom functions

  2022-06-01 17:02:42 Views: 266
• 

  Mysql queries table data through commands

  Mysql queries table data 1. 1 by command. Syntax: SELECT field 1, field 2. Field nFROM table name AS alias WHERE condition [GOURP BY grouped field] [HAVING grouped query condition] [ORDER BY sort

  2022-06-01 17:02:34 Views: 210
• 

  The most complete Oracle-SQL Notes (8)

  1.8. Database design paradigm database design paradigm is actually very important, but from the perspective of actual development, if it is really done in accordance with the paradigm, the program can not be written, including query statements will become complex. All the tables of scott users in Oracle are actually already

  2022-06-01 17:02:33 Views: 217
• 

  Rhel7.4 install oracle 11G

  1. The file p13390677_112040_Linux-x86-64_1of7.zip-database softwarep corresponding to operating system red hat 7.4oracle database version 11.2.0.4

  2022-06-01 17:02:03 Views: 258
• 

  The difference between where and having in Oracle

  First of all, where is for a single statement and having is for groups. And the priority is where > group by > having. It should be noted that 1.where is 2.having and 2.having that cannot be placed after group by.

  2022-06-01 17:02:03 Views: 221
• 

  Use of BBED tool

  Oracle Block Brower and EDitor Tool (bbed) tool, a tool used to view and modify data file data directly, is an internal tool of Oracle that can directly modify the contents of Oracle data file blocks.

  2022-06-01 17:02:03 Views: 292
• 

  Oracle performance tuning Learning 0621

  1.PLAN_tablecolumn query_plan format a55column cardinality format 99999column cost format 99999delet

  2022-06-01 17:02:03 Views: 288
• 

  ITL contention-oracle has deprecated the MAXTRANS parameter.

  If you do not specify any (physical_attributes_clause) parameters when creating a table: If you omit this clause, then Oracle Database sets P

  2022-06-01 17:02:02 Views: 245
• 

  Vnc install Oracle

  Enter the / u01/softwares/ directory and extract the two Oracle files # unzip oracle_Linux-x86-64_1of.zip#unzip oracle_Linux-x86-64_2of

  2022-06-01 17:02:02 Views: 216
• 

  Database connection and Encapsulation of Sina Cloud web Project

  [key] Class.forName ("com.mysql.jdbc.Driver"); / / the database connection statement declares conn = DriverManager.getConnection ("jdbc:mysql")

  2022-06-01 17:02:02 Views: 224
• 

  Oracle VM VirtualBox installation system reported an error

  The following message is prompted when installing centos6.5 using virtual machine Oracle VM VirtualBox: This kernel requires the following features not present

  2022-06-01 17:02:02 Views: 278
• 

  Some tables that start with BIN$ appear after the table is deleted

  First, I believe that many friends have had this experience. When executing drop table * and then select * from tab, there will be a lot of tables that start with BIN$. This is because after deleting the table, the Recycle Bin is not cleared, such as Win.

  2022-06-01 17:01:54 Views: 253