NAV: SLTechnology News&Howtos > Database >

• 

  Common functions of MySQL

  1. String class function (1) CONCAT (s 1m 2 m s 3.) The connection string for example: SELECT CONCAT ('1century relegation 2') FROM DUAL; output: 12 (2) LOWER (s) turns all the strings into

  2022-06-01 07:12:24 Views: 275
• 

  Mysql + keepalive high availability build

  Mysql + keepalive high availability build system environment: centos6.8Ip:192.168.137.36 master library 192.168.137.38 slave library VIP (virtual ip/ floating ip): 192.168.137.

  2022-06-01 07:12:24 Views: 215
• 

  [Mysql] find the binlog information of a single table from binlog

  Boring research binlog wrote an information to extract the binlog of a single table to facilitate mistakenly deleting and restoring data. The purpose of this is to reduce errors that may be caused by other tables during recovery, and to shorten the recovery time. First of all, study the format of the binlog log as follows: / *! 50530 S

  2022-06-01 07:12:24 Views: 244
• 

  Description of common parameters of Percona Xtrabackup innobackup

  -- defaults-file parameter of defaults-file and xtrabackup-- encapsulation of xtrabackup-- prepare parameter by apply-log-- when copy-back performs data recovery

  2022-06-01 07:12:23 Views: 277
• 

  The opatch auto automatic way of patching GI PSU hits GI_HOME and ORACLE_HOME respectively.

  11.2.0.4 patching rac database: environment description: [oracle@dbrac1 ~] $cat / etc/issueRed Hat Enterprise Linux Server release 6.7

  2022-06-01 07:12:23 Views: 297
• 

  MySQL UDF at in (subquery where) bug

  SELECT 45, COUNT (0) FROM ac_dealer_sales dsWHERE ds.user_id in (SELECT du.user_id FROM ac_dept_user d

  2022-06-01 07:12:19 Views: 212
• 

  Oracle RAC modifies the parameter file location

  Objective: to modify the original location of the parameter file from + DATA/cjcdb/spfilecjcdb.ora to + DATA/cjcdb/spfile/spfilecjcdb.ora. The steps are as follows: 1: temporary location to generate pfile Note: RAC ring

  2022-06-01 07:12:15 Views: 253
• 

  RAW Image processing tool DxO PhotoLab 3 for Mac v3.3.1

  What's the number of the image processing tool? DxO PhotoLab Mac is a digital photo processing software on the Mac platform. The DxO PhotoLab Mac version has powerful image processing functions and editing logic, allowing you to simply deal with the photo of your own.

  2022-06-01 07:12:12 Views: 302
• 

  PostgreSQL source code interpretation (82)-query statement # 67 (PortalXXX series functions)

  This section describes the PortalXXX functions, which are called in create_simple_query, including CreatePortal, PortalDefineQuery, PortalSetResultFormat

  2022-06-01 07:12:12 Views: 298
• 

  Sqlldr

  Recently, I am dealing with a batch of text data, which is required to be imported into the ORACLE database in accordance with the interface instructions. After recent research, I have solved some problems. I feel that I need to sum up: general information:--

  2022-06-01 07:12:12 Views: 252
• 

  ORA-31633: unable to create master table & quot;SYSTEM.SYS_EXPORT_FULL_XX"

  ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_FULL_XX" EXPDP in Oracle 12c (12.1.0.2) f

  2022-06-01 07:12:04 Views: 217
• 

  Wondershare PDFelement 7 Pro for Mac (pdf editing software)

  Which PDF editing software works well? Today, the editor shares PDFelement 7 Professional Edition, which can quickly and easily edit and annotate PDF, create PDF and convert it to other file formats, fill out forms and easily sign contracts, making it convenient for your work! What are you waiting for?

  2022-06-01 07:12:04 Views: 206
• 

  Library cache structure and Library cache lock, Library cache pin wait events

  1. The description of Library Cache in Library cache structure 1.DSI: (1) An area in the shared pool that manages information abo

  2022-06-01 07:11:56 Views: 262
• 

  How to view the development prospect of FoundationDB database?

  If data is the "oil" of science and technology, then the database is the oil well. No matter which program or platform you use, you must have a database. The database is so important that all the giant enterprises are grabbing the database market. In the field of open source technology, databases have grown wildly.

  2022-06-01 07:11:53 Views: 280
• 

  How to convert voice into text? What is the method of voice-to-text operation?

  In this day and age, voice transmission is a very common way. When we receive voice files, how do we convert voice into text? If we learn this kind of operation can save a lot of time at work, the editor will share with you the method of converting voice to text. Let's take a look.

  2022-06-01 07:11:38 Views: 245
• 

  Oracle backup and recovery-concept

  Backup and restore [TOC] 1. What is backup and recovery? There is only one meaning of    backup and recovery is to protect the database (to protect the data and itself) and to prevent database damage or data loss due to equipment failure or human misoperation. Even if the lost data can not be recovered.

  2022-06-01 07:11:38 Views: 225
• 

  How to choose the appropriate small project management tool?

  Small-scale projects usually refer to projects whose workload is between three to more than ten people. this kind of projects are generally laissez-faire with little management, and usually have the characteristics of low investment, small personnel, tight time, unclear needs and so on. For example, with the help of small project management tools, we can save a lot of time, avoid waste of resources and improve project efficiency.

  2022-06-01 07:11:35 Views: 271
• 

  About deleting data from the Oracle database

  1. Delete the table drop1.1 after the drop table table_name statement is drop, the table is placed in the user Recycle Bin (user_recyclebin) instead of being deleted directly, and the table in the Recycle Bin can be restored. Pass

  2022-06-01 07:11:34 Views: 253
• 

  W10 install Redis

  W10 install Redis ①: installation steps (give rookie tutorial address) ​ https://www.runoob.com/redis/redis-install.html ②: check whether port 6379 is occupied and modify W10

  2022-06-01 07:11:32 Views: 278
• 

  PL/SQL programming _ flow Control statement of Oracle

  Select statement 1. If...then statement syntax: if < condition_expression > thenplsql_sentenceend if;condition_expression: represents a

  2022-06-01 07:11:31 Views: 264