NAV: SLTechnology News&Howtos > Database >

• 

  Mysql notes-basic additions, deletions, changes, queries and table structure of the database

  Basic database additions, deletions, changes and queries 1, add-add / insert data, which table does insert into insert, which columns, what values, statements: insert into table name (column 1, column 2, column 3) values (value 1, value 2, value 3); you can not follow the sequence of the original column

  2022-06-01 12:59:56 Views: 250
• 

  Detailed record of mongodb 3.2.5 installation process

  2016-10-19 mongodb 3.2.5 installation 1 ready to install media installation media download: mongodb installation method, I usually use binary package, the internal network can not be configured to connect to the external network yum source; the official recommended mongodb download address is

  2022-06-01 12:59:56 Views: 205
• 

  Application of MongoDB relation-1 to multi-reference relation

  1. Check the database show dbs2. Use database use test3. View the collection show collections4 in the database. Add data to the address collection and create a db.address if the address does not exist

  2022-06-01 12:59:29 Views: 284
• 

  Centos 7 about rc.local script command boot not executed and specified

  1. Boot does not start in the actual production scenario, we like to set the software to boot self-startup after installing some software services, and there are two ways to set it to boot self-startup: 1) set to chkconfig, you can write scripts to view the command to set boot self-startup-add indicates

  2022-06-01 12:59:28 Views: 215
• 

  DELETE, TRUNCATE and DROP

  Function DELETEdelete is a data manipulation language, which can delete the records specified by the where statement in the table, retain the table structure, and do not release storage space. TRUNCATEtruncate is a data definition language that clears the table, which is equivalent to deleting all the data in the table and keeping the table knot.

  2022-06-01 12:59:20 Views: 271
• 

  Summary of functions used in oracle development

  1.decode meaning explanation: decode (condition, value 1, return value 1, value 2, return value 2. Value n, return value n, default value) the meaning of this function is as follows: IF condition = value 1 THENRETURN (translation value 1) ELSIF condition = value 2

  2022-06-01 12:59:00 Views: 207
• 

  Install MongoDB 4.0in Centos 7 [3.2.1]

  Introduction to MongoDB = MongODB is a cross-platform, document-oriented database. It can achieve high performance, high availability, and can be easily scaled. Is an open source database system based on distributed file storage.

  2022-06-01 12:59:00 Views: 241
• 

  Oracle GoldenGate Learning-heterogeneous platform synchronization (Mysql to Oracle)

  Oracle GoldenGate learning-heterogeneous platform synchronization (Mysql to Oracle) is shown in the figure: the source side uses Mysql library, the target side uses Oracle library 1, OGG installation configuration (source side) 1, and OGG downloads https://ed

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

  Oracle GoldenGate Studio 12.2.1.3 installation-RCU configuration

  After completing the OGG Studio12.2.1.3 installation, use Repository Creation Utility (RCU) to create a Repository to store related projects, solutions, mapping, and deployment

  2022-06-01 12:58:21 Views: 262
• 

  Oracle GoldenGate Learning-- installation and configuration of AIX system

  Oracle GoldenGate learning-- AIX system installation and configuration system environment operating system: AIX5.3-09DB Soft: Oracle 10gR2 as shown in the following figure: the system environment actually builds an one-way OGG download OG on the AIX system.

  2022-06-01 12:58:17 Views: 233
• 

  Detailed explanation of compiling and installing LAMP (php-fpm) steps

  Content: part 1: compile and install LAMP (php works as a module) part 2: compile and install LAMP (php works as fpm) part 1: we know that there are several ways to combine apache and php: the first one: put php

  2022-06-01 12:58:08 Views: 253
• 

  9. MySQL stored procedures and functions

  A stored procedure is a collection of one or more SQL statements that can be treated as batch files, but its role is not limited to batch processing. 9.1.Creating stored procedures and function stored procedures can be divided into stored procedures and functions. The statements used to create stored procedures and functions in MySQL are CREATE, respectively.

  2022-06-01 12:58:07 Views: 236
• 

  An example of Skype for Business error processing for Lync in-place upgrade

  Lync Server 2013 upgrade Skype for Business Server 2015 so so easy, So do. Everything is carried out step by step, all the way through the customs to kill demons, install the necessary IIS KB patches, SQL

  2022-06-01 12:58:07 Views: 272
• 

  DBMS Introduction

  RDBMS (Relational Database Management System) relational database: the structure of a relational database: row: row, record, also known as record column: column, field, attribute or field Pr

  2022-06-01 12:58:07 Views: 242
• 

  Mongodb replica set

  System: centos6.5IP:10.19.21.244 primary node 10.19.21.245 standby node 10.19.21.248 arbitration point is not only the primary node, replica node, arbitration node, but also Secondary-Only, Hid

  2022-06-01 12:58:07 Views: 264
• 

  Mysql data operation

  First, insert data INSERT1. Insert complete data (sequential insert) syntax 1: INSERT INTO table name (field 1, field 2, field 3 … Field n) VALUES (value 1, value 2, value 3... Value n); syntax 2: INSERT INT

  2022-06-01 12:58:07 Views: 263
• 

  Mysql Foundation (7) select statement

  Single table query: SELECT [DISTINCT] [SQL_CACHE | SQL_NO_CACHE] select_expr [, select_ex

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

  An example of oracle Database failure cannot allocate new log

  The database has the following error analysis: when the database switches logs, all private strand must be flushed to the current log before continuing. This information indicates that we have not fully written all the redo information to the log when we tried to switch. It's kind of like "

  2022-06-01 12:58:03 Views: 210
• 

  Delete commands in T-SQL (drop, truncate, and delete)

  1, DROP command: syntax: drop table data table-delete the entire table (including table structure definition), the fastest, the most thorough, did not save the specific log (delete content and definition, free space. Is to remove the whole table.), basically can not restore 2, T

  2022-06-01 12:58:03 Views: 233
• 

  Install oracle under linux in the virtual machine

  Install oracle under linux in the virtual machine, see attachment: http://down.51cto.com/data/2366451

  2022-06-01 12:58:03 Views: 297