NAV: SLTechnology News&Howtos > Database >

• 

  Detailed description of sql_mode settings in MySQL or MariaDB

  See the "Server SQL Modes" section of the MySQL5.6 manual for details. Address: http://dev.mysql.com/doc/refman/5.6/en/sql-mode.html referenced blog posts from several websites

  2022-06-01 21:49:08 Views: 265
• 

  Mysql5.6 backs up scripts and sends emails

  1. Full inventory: #! / bin/bash#name: full library backup#backup directoryback_Dir=date +% Y-%m-%d#create backup di

  2022-06-01 21:49:08 Views: 301
• 

  INS-20802 PRVF-4664 PRVF-4657: Found inconsistent name resolution entries for SCAN name

  PRVF-4664 PRVF-4657: Found inconsistent name resolution entries for SCAN name (document ID 887471.1) In thi

  2022-06-01 21:49:07 Views: 282
• 

  Installation and use of non-relational database-MongoDB

  MongoDB Overview MongoDB is a product between relational database and non-relational database, which is the most feature-rich and most like relational database among non-relational databases. It supports a very loose data structure and is a bson format similar to json, so it can store complex data.

  2022-06-01 21:49:07 Views: 233
• 

  Quickly master database index technology [database design]

  Classification of indexes: general index, primary key index, unique index, full-text index, composite (combined) index. When to create an index: (1) fields that are used more frequently as query conditions; (2) fields with poor uniqueness (such as gender / status fields, etc.), even if we frequently use them as query conditions

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

  Collation of common functions in Oracle

  Wm_concat (lie [,'|']) column turns to row rount (lie,2) retains the decimal point

  2022-06-01 21:48:58 Views: 238
• 

  The whole process of installing mongodb in production

  Install mongodb operating system on mongodb-linux-x86_64-4.0.2.tgz production for centos6.5 first step execute optimization script initialization script step 2: upload mongodb binary installation package [root@p

  2022-06-01 21:48:58 Views: 250
• 

  & # 8203; instance management and database startup / shutdown

  Instance management and database startup / shutdown 2.1instances and parameter files 1. Instance function: used to manage and access database. Instance reads the initialization parameter file (init parameter files) during the startup phase.

  2022-06-01 21:48:53 Views: 234
• 

  Troubleshooting of ORA-04031:unable to allocate 4120 bytes of shared memory 'obj stat mem'

  Customer report library, HP-ux B11.31 IA64 FOR Oracle 10.2.0.5.0 RAC system SMS filtering alert log alarm ORA-00604: error occurred at recursi

  2022-06-01 21:48:50 Views: 224
• 

  How does mysql count the number of people in each major score segment?

  How does mysql count the number of people in each major score segment? The following by the editor to give you a detailed introduction; 1. My table structure student_info | id | name | profession | score | |-| | id

  2022-06-01 21:48:45 Views: 225
• 

  Nfs shared directory and mount

  Experimental content: (1) nfs server export / data/application/web, provide wordpress; (2) nfs client mount nfs server exported file system to / var/ww in the directory

  2022-06-01 21:47:45 Views: 296
• 

  What are the methods for redis to monitor the expiration of key

  Recently we found an interesting problem in the Redis cluster. After spending a lot of time debugging and testing, we can reduce the key memory usage in some clusters by 25% by changing the Redis expiration. To enable redis to listen to key expiration, you need to add a configuration.

  2022-06-01 21:47:42 Views: 221
• 

  Day_19-Django (2)

  Summary of this section: first, routing system URL II, View 3, template 4, ORM Operation problems 1:Django request Lifecycle-> URL correspondence (matching)-> View function-> return user string-> URL correspondence (matching)-> View

  2022-06-01 21:47:41 Views: 237
• 

  The solution of Multiple primary key defined error prompt in MySQL

  There are two ways to create a primary key: create table table name (field name type, field name type,... Primary key (name)); or create table table name (field name type primary key)

  2022-06-01 21:47:28 Views: 264
• 

  [MongoDB Learning Notes 15] MongoDB query: find query condition

  Find can match more conditions than precise queries. First, the comparison operator $lt represents <; $lte stands for < =; $gt stands for >; $gte stands for > =; > db.post.find () {"_ id": ObjectId ("

  2022-06-01 21:46:58 Views: 211
• 

  Oracle register listener, change port

  Static registration changes port 1521 in listener.ora and tnsnames.ora to 1421, and it is very simple to dynamically register 2.1 to change the port in the listener.ora file to 1421LISTENER = (DESCR)

  2022-06-01 21:46:58 Views: 214
• 

  Mud: phpmyadmin password-free configuration for database management

  This article is sponsored by ilanniweb. It was first posted in Mudhang World. If you want to get more articles, you can follow my Wechat ilanniweb. Actually, I wanted to write this article a long time ago, but I haven't had time. I happened to be a little free this afternoon, so I sorted out this article. Yes

  2022-06-01 21:46:58 Views: 302
• 

  UniDAC usage tutorial (1): connect to a database

  Download the latest version of UniDAC Universal Data Access Components (UniDAC) is a general database access component that provides direct access to multiple databases, such as Delphi for Windows, C

  2022-06-01 21:46:58 Views: 290
• 

  NetScaler official website document resource navigation

  NetScaler deployment guide, including Microsoft, Cisco, Oracle,PaloAlto,AWS and many other deployment guides, constantly adding https://www.citrix.com/products/netscaler-adc/

  2022-06-01 21:46:45 Views: 219
• 

  Record the irresponsible practice of archiving and exploding a guide library

  The test pilot data validates another problem, but it stays stuck when it is suddenly imported. Then I looked at the log and found that a large number of archive logs were generated during the impdp import process, and the storage space for archives was full, so the tail / u01/app/oracle/diag/r was stuck.

  2022-06-01 21:46:45 Views: 255