NAV: SLTechnology News&Howtos > Database >

• 

  A complete Collection of Common functions in sqlserver

  First, the string function datalength (Char_expr) returns the string containing the number of characters, but does not contain the following space substring (expression,start,length). Say no more, take the substring right (ch)

  2022-06-01 12:21:49 Views: 221
• 

  Oracle exports all objects under a single user

  Exp scott/m123 buffer=64000 file=/u01/scott.dmp owner=scottimp scott/m123 buffer=64000 file=/u01/sco

  2022-06-01 12:21:49 Views: 296
• 

  CacheEasy-Redis private cloud platform

  Why use the redis private cloud platform? Manual and script maintenance of a large number of redis services is time-consuming, laborious and error-prone. When establishing equivalent redis services is a complex thing, people are easy to be lazy, and different businesses mix with the same redis, which is easy to influence each other to expand and reduce capacity.

  2022-06-01 12:21:30 Views: 287
• 

  Redis redo Connection with master lost error from Library Times

  Background: when initializing the redis instance, my colleague gave the monitor command to rename. Today, there happens to be a problem in this group of instances. We need to use the monitor command to help analyze the problem. It turns out that the monitor command cannot be used because the redis command is renamed.

  2022-06-01 12:21:30 Views: 290
• 

  [actual combat of production warehouse] using stored procedures to archive the data of the history table of the production line

  Production line historical data archiving is a daily basic work of database operation and maintenance. When building tables, data pipeline tables (such as logs, user login history, software download records, user attribute change history tables, etc.) are usually designed as range partition tables, interval partition tables (11G), when exceeding business requirements.

  2022-06-01 12:21:30 Views: 215
• 

  Puppet syntax check

  Puppet syntax check it is best to do a grammar check after editing the .pp file to check out the syntax errors in the .pp file in advance. Puppet parser validate init.pp

  2022-06-01 12:21:30 Views: 252
• 

  Mybatis3+Spring4+SpringMVC4 integration [transfer]

  First of all, when integrating this framework, think about what the general steps are. After there is a step first, it will not be confused later, so that it will be clearer during the integration. Then we integrate it step by step. 1 create a Web project. 2 Import Mybatis3

  2022-06-01 12:21:11 Views: 291
• 

  Generate CDM, PDM, and SQL using PowerDesigner

  1. Personnel organizational structure entity remarks organization (id, name) department (id, name) an organization has multiple department personnel (id, name) A person belongs to a department, and a department has multiple personnel leaders are also personnel roles (id, name) A role can correspond to multiple personnel, one

  2022-06-01 12:20:44 Views: 251
• 

  Mongodb backup mongodump and restore mongorest

  Backup the specified database: mongodump-u=u_app-p = "password"-h 10.11.55.203-- port 27017-d db_chunqiu-o / backup/ back up all

  2022-06-01 12:20:43 Views: 292
• 

  Com.mysql.jdbc.Driver = "com.mysql.cj.jdbc.Driver

  Error message: SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@16676fb7] was not registered f

  2022-06-01 12:20:43 Views: 214
• 

  Linux-rpm,yum

  Linux main directory / boot/etc/usr/var/dev/lib/tmp/bin/sbin/proc/sys/mnt/media/home/root/misc/opt/srv/usr/share/

  2022-06-01 12:20:43 Views: 283
• 

  Redis Cluster cluster deployment build

  After walking on the road of Oracle for many years, it is also a good feeling to change my feeling and try some new knowledge. Redis, an ultra-lightweight in-memory database, only does a small piece of database function, but it is a very excellent product. Today, let's share the installation of Redis clusters.

  2022-06-01 12:20:43 Views: 251
• 

  Introduction and usage of btrfs file system

  Btrfs file system: Btrfs (B-tree file system, usually pronounced Butter FS,Better FS or Btree FS), licensed by GPL, announced by Oracle in 2007 and in progress

  2022-06-01 12:20:39 Views: 288
• 

  Patent: structured big data Communication Protocol (2)

  Explanation 2: the uniqueness of data is the basis for the realization of "data GSM". In a small environment such as classes and groups, each person can be distinguished by his or her name, but in the whole country, because there are too many people, there are many duplicate names. therefore, the name alone can not accurately identify everyone. When big data

  2022-06-01 12:20:38 Views: 211
• 

  An actual Battle of oracle Export and Import

  Just arrived at the company not long, there is an oracle server to export, import, before contact with oracle, but to oracle export, import has not been studied, this anxious bad me, so quickly surf the Internet to make up for it. The operation results are as follows: Oracle data export and import

  2022-06-01 12:20:38 Views: 301
• 

  The case of Oracle Study-- controlfile diversification on RAW

  The case of Oracle Study-- controlfile diversified system environment on RAW: operating system: AIX 5300-08 Database: Oracle 10.2.0.1 after building the database through dbca, there are two control files, and then add

  2022-06-01 12:20:38 Views: 254
• 

  Collation of mysql basic commands (2)-revision

  1. Create two new data tables offices and employees in the test_tb2 database, as follows: mysql > DESC offices;+-

  2022-06-01 12:20:37 Views: 234
• 

  ORA-0019 invalid specification for system parameter LOCAL_LISTENER

  SQL > startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid li

  2022-06-01 12:20:37 Views: 213
• 

  Redis distributed database

  1. Key pattern query corresponding key1) redis allows fuzzy query key to have 3 wildcards,?, []: any number of characters?: single character []: 1 character in wildcard parentheses 2) randomkey: returns random

  2022-06-01 12:20:23 Views: 268
• 

  Data acquisition course recording plan

  In the latest half of a year, one of our projects collects Internet data for customers. We have conducted in-depth research on the collection tools, and we have also developed a collection program. We plan to share this tool with you and record it into a set of courses. Please look forward to recording another set of product development courses in the future.

  2022-06-01 12:20:18 Views: 298