NAV: SLTechnology News&Howtos > Database >

• 

  MySQL5.7.26 source code compilation and installation

  1. Install the dependent component yum-y install gcc gcc-c++ pcre pcre-devel openssl openssl-develyum-y install zlib zlib-dev

  2022-06-01 09:48:38 Views: 201
• 

  Detailed explanation of CURD Operation of mongodb

  Basic operations add, delete, change, check and add: insert introduction: mongodb stores documents. A document is an object in json format. Syntax: db.collectionName.isnert (document); 1: add a single document Db

  2022-06-01 09:48:22 Views: 297
• 

  Build MongoDB server, basic use of MongoDB, import and export of data

  MongoDB1.1 software introduces the product between relational database and non-relational database-a database based on distributed file storage. -written in C++ language. Designed to provide scalable high-performance data storage solutions for WEB applications. -Mong

  2022-06-01 09:48:21 Views: 227
• 

  Java connects to Oracle database

  Use java to connect to Oracle database for simple query use sys login to sql plus to create user create user user identified by password; authorize grant connect,resource t

  2022-06-01 09:48:21 Views: 248
• 

  SqlServer series notes-trigger 2

  First, creating a simple trigger trigger is a special stored procedure, similar to an event function. SQL Server allows you to create triggers for INSERT, UPDATE, and DELETE, that is, to trigger one or a series of records when inserting, updating, or deleting records in a table.

  2022-06-01 09:48:21 Views: 237
• 

  I wrote an one-click install MySQL script-- violent version

  [root@xd-10-189songlisha] # cat install_mysql.sh #! / bin/bashmysql_src=/songlisha/home/admin/mysql_da

  2022-06-01 09:48:18 Views: 240
• 

  Transaction processing of JDBC programming

  The basic concept of transaction database is a shared resource used by multiple users. When multiple users access data concurrently, multiple users will access the same data at the same time in the database. If there is no control over concurrent operations, incorrect data may be read and stored, and the data may be destroyed.

  2022-06-01 09:48:11 Views: 263
• 

  Postgresql database-summary of data types

  The data type postgresql of postgresql database supports a variety of data types, including integer type, floating point type, arbitrary precision value, date-time type, string type, binary type, Boolean type and array type. 1. Integer type post

  2022-06-01 09:48:11 Views: 256
• 

  MongoDB aggregation Pipeline (Aggregation Pipeline)

  In the pipeline concept POSIX multithreading, there is a very important way-pipelining (also known as "pipeline"), in which the "data element" stream is executed sequentially by a set of threads. Its architecture can be seen in the following figure: in terms of object-oriented thinking, the whole pipeline

  2022-06-01 09:48:11 Views: 311
• 

  Oracle Open online course "SQL Optimization: you are not alone in the fight"

  Optimizing SQL is a laborious technical task, constantly analyzing execution plans, adding hint, indexing, analyzing statistics, and so on. Don't worry, you're not fighting alone. Starting from 10g, Oracle launched its own auxiliary tool for SQL optimization: SQL optimizer (SQL T)

  2022-06-01 09:48:08 Views: 292
• 

  Install the Percona Server database (in CentOS

  In the article of building PXC cluster under CentOS8, it introduces how to build Percona Server cluster. In fact, the installation package of PXC is already bundled with Percona Server, so some of Percona Server will be blocked during installation.

  2022-06-01 09:47:58 Views: 225
• 

  Ubuntu simple installation of Mongodb

  Ubuntu simple installation of Mongodb system: ubuntu 12.04 x64 below describes the easiest way to install 1. Add the update source of domestic 163First backup Ubuntu12.04 source list sudo cp / etc/apt/so

  2022-06-01 09:47:58 Views: 275
• 

  What's New in MariaDB 10.4

  MariaDB 10.4 is its current development branch. On May 21st, the 10.4.5 RC release version was released, which is getting closer and closer to the official release. The new features of 10.4 are also of increasing concern. This article summarizes some blogs officially released by mariadb.

  2022-06-01 09:47:58 Views: 295
• 

  Oracle move and shrink release High Water level Space (1)

  What move and shrink have in common 1, shrink segment 2, eliminate partial row migration 3, eliminate space debris 4, make data more compact 1, shrink syntax: alter table TABLE_NAME shrink space [compa

  2022-06-01 09:47:58 Views: 215
• 

  Introduction to mysql database

  What is a database: a database is a data storage and management software that interacts with applications, and those that store data can also be called databases. In the past, when you did not use the database, you could only write your own data storage scheme. What is the sql statement: the Sql statement is used against the database

  2022-06-01 09:47:49 Views: 208
• 

  Reasons for the 8-hour difference between MySQL5.7 slow query log time and system time

  When checking the slow query, it is found that the time is wrong, which is exactly 8 hours different from the system time. 1. The display time of slow query is as follows: # Time: 2020-01-10T06:42:24.940811Z2, system time $dateFri Jan 1

  2022-06-01 09:47:48 Views: 211
• 

  Copy the database to another database under the same instance

  If you want to replace any variable, copy and paste directly, and the program will run and go. #! / bin/bash# copies the hellodb data into the hellodb_ Bak library. Mysql-uroot-pAbcd@1234-h 10.0.20

  2022-06-01 09:47:48 Views: 292
• 

  Web fox source code erection: MatchID configuration error

  This article is quoted in: journey Source Forum (www.zhengtuwl.com)-focus on all kinds of fine products × × × platform Internet Fox × × × Source Code Construction FAQ: [configuration error] MatchID configuration error. The solution to MATCHID is the house.

  2022-06-01 09:47:34 Views: 283
• 

  Introduction to postgresql-- operator

  Postgresql has a wealth of internal operators, which can be divided into four main categories: arithmetic operators, comparison operators, logical operators, and bit operation operators. As follows: ①: arithmetic operator: used for all kinds of numerical operations, including addition (+) minus (-) multiplication (*) division (/) remainder (%)

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

  Write after SQL injection

  1. Functions can only be called directly after query statements, but stored procedures can not be called directly. For example, select function () from dual can be used, but select procedure () from dual can not; 2. In the query statement

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