NAV: SLTechnology News&Howtos > Database >

• 

  Database objects: tables, views, indexes, sequences (basic 1)

  Create tables: CREATE TABLE employee_xxx (id NUMBER (4), name VARCHAR2 (20), gender CHAR (1), birth DATE,salary NUMBER

  2022-06-01 09:35:31 Views: 279
• 

  Use sql to count the amount of data in every ten minutes

  In the mysql database, use SQL to calculate the amount of data within ten minutes; first, the table structure: the desired result is: how many schemes 1:select from_unixtime (floor (UNIX_) are there in every ten minutes of user_id

  2022-06-01 09:35:31 Views: 217
• 

  Zabbix Agent proxy installation configuration

  Zabbix proxy is installed on another machine and uses a different database than zabbix server to avoid data confusion. Zabbix proxy uses zabbix version 2.2.0 (1) to download the zabbix installation package wget

  2022-06-01 09:35:19 Views: 284
• 

  Rsync remote synchronization (regular synchronization, real-time synchronization actual combat! )

  This chapter introduces the structure of 1.rsync synchronization 2. Configure rsync backup source 3.rsync command basic usage 4.rsync backup operation sample 5.rsync+inotify in conjunction with about rsync. A fast incremental backup tool 1.Remote

  2022-06-01 09:35:01 Views: 261
• 

  RAC basic architecture

  In the RAC cluster, cache fusion-- GCS: implements the replication and transfer of data blocks between instances-- GES: manages locks PCM_Lock and Non_PCM_Lock (to coordinate node values)-Lock manager DML--

  2022-06-01 09:34:58 Views: 293
• 

  The difference between binlog-format

  Which log format should be used for the primary server? There are statement,row and mixed3 species, and mixed refers to the mixture of the first two species. Take the example of insert into xxtable values (xQuery yjinz), influence: 1 line

  2022-06-01 09:34:57 Views: 272
• 

  Oracle performs binary conversion through functions

  Convert hexadecimal to decimal: to_number () SQL > select to_number ('axiomagy dongx') from dual;TO_NUMBER (' axiomaix')-

  2022-06-01 09:34:45 Views: 200
• 

  Upgrade from Exchange2010 to 2016-configure Exchange2016 mailbox database, migrate mailbox

  In the last article, we completed the configuration of the connector and DNS. Let's create a new Exchange2016 mailbox database, and then migrate the Exchange2010 mailbox to 2016Exchange2016 new database Exchange20.

  2022-06-01 09:34:45 Views: 245
• 

  Oracle study notes

  Oracle installation 1. Install virtualbox:# yum install gcc kernel-devel kernel-headers# yum install virtualbox-5....#

  2022-06-01 09:34:41 Views: 298
• 

  Tomcat Settin

  C:\ KSOAWS\ tomcat\ webapps\ ROOT\ WEB-INF\ classesproxoolC:\ KSOAWS\ tomcat\ confserverC:\ KSOAWS\ tomcat\ bins

  2022-06-01 09:34:35 Views: 239
• 

  DotConnect for Oracle getting started Guide (4): inserting data into tables

  [download the latest version of dotConnect for Oracle] dotConnect for Oracle (formerly known as OraDirect.NET) is based on ADO.NET technology and provides services for applications based on Oracle databases

  2022-06-01 09:34:35 Views: 226
• 

  Orchestrator High availability yum Quick installation process

  [root@mgr1 ~] # curl-s https://packagecloud.io/install/repositories/github/orchestrator/script.rpm.s

  2022-06-01 09:34:35 Views: 245
• 

  Static and dynamic registration

  The create listener listener is defined in the listener.ora file, which is stored in the ORACLE_HOME/network/admin directory by default. The listener.ora file must declare at least the name of one listener and the

  2022-06-01 09:34:34 Views: 207
• 

  Common str functions in MySQL

  Common string functions in MySQL are organized from official files. 1.1 SUBSTR or SUBSTRINGSUBSTR (str,pos), SUBSTR (str FROM pos), SUBSTR (str,pos,len)

  2022-06-01 09:34:16 Views: 223
• 

  Remote connection oracle database settings

  First find the listener.ora file on your computer and change HOST=localhost to the hostname because remote access is not possible with localhost. ... / app/Oracle/product/11.2.0/db

  2022-06-01 09:34:16 Views: 217
• 

  What is the difference between in and exists and between exists and distinct de-weighting?

  Editor believes that we all know the difference between in and exists: 1, the use of different sql in is suitable for sub-query result set records are less, the main query table is larger and indexed table. In sql, exist applies to the outer layer of the main query with fewer records, and the table in the subquery is larger.

  2022-06-01 09:34:16 Views: 261
• 

  Introduction and configuration of Master-Slave replication of MySQL

  1.MySQL Master-Slave replication introduction MySQL database supports replication in different business scenarios such as one-way, two-way, chain cascade, ring, and so on. During replication, one server acts as the master server (Master), receiving content updates from users, while one or more other servers act as

  2022-06-01 09:34:03 Views: 299
• 

  Introduction to tables and indexes of Oracle objects

  For traditional relational database management systems (RDBMS), such as Oracle and MySQL, data are stored and retrieved in the database. In Oracle, schema is used to represent a collection of logical data structures or schema objects, which are user-created and used to

  2022-06-01 09:33:59 Views: 251
• 

  Mysql self-connection

  # case: query the name of the employee and the name of the superior, find the superior id through the employee name, and then find the employee name of the superior through the superior id.

  2022-06-01 09:33:47 Views: 260
• 

  MySQL in-table operation of 3Python full stack path series

  Python full Stack path series MySQL table operations create a table for testing-- create a database CREATE DATABASE dbname DEFAULT CHARSET utf8 COLLATE utf8_ge

  2022-06-01 09:33:47 Views: 233