NAV: SLTechnology News&Howtos > Database >

• 

  [MySQL Learning Notes] 2. SQL statement

  1. SQL statement SQL:Structured Query Language, structured query language, is the language for the dialogue between the client and the SQL server to talk to the SQL server belongs to the interpretation and execution programming language, its code file is usually called script, directly

  2022-06-01 18:21:03 Views: 255
• 

  [ORACLE DATAGUARD] the process of switchover

  1. Check the status of the main library: SQL > SELECT SWITCHOVER_STATUS FROM database access SWITCHOVERVERVERTSTATUSmurto STAN

  2022-06-01 18:20:40 Views: 202
• 

  Report Builder 3.0 report access Settings

  1. Authorization by site is applicable to viewing all report permissions. Generally, the administrator step 1: grant home folder access first, step 2: click [site Settings] in the upper right corner to authorize all folder permissions step 3: [new role assignment] 2. Or report authorization by folder step 1, authorize access to the main folder first

  2022-06-01 18:20:40 Views: 295
• 

  The way to get started with java

  Java is object-oriented programming, and I think memory is more important. The first stage java basic part unix development environment proficiency in the development of the commonly used operating system linux installation and use: master file system, network, user management methods: proficient in the use of vi and vim

  2022-06-01 18:20:39 Views: 280
• 

  MongoDB Replica Set troubleshooting

  1. Check the status of Replica Set using db.runCommand ({"replSetGetStatus": 1}); or rs.status (); 2. Check replication delay time source: m1.exa

  2022-06-01 18:20:39 Views: 272
• 

  Python calls mongodb to send Wechat Enterprise account.

  Python2.x Note: in the data variable, agent_id is the newly created application id (which can be seen on the web page) toparty is the target department, or you can use touser,totag to specify the target account for a relatively simple call. It has been tested, but

  2022-06-01 18:20:39 Views: 244
• 

  Db2 v10 installation

  Select the installation version: select the keyword to install the DB2 product, version V10.5, here choose to enter SERVER (server) SERVER server version CONSV link server version EXP simplified version CLIENT data server client RTCL data server

  2022-06-01 18:20:38 Views: 202
• 

  Database management tool Navicat Premium, using SQL C

  Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases simultaneously with a single program, making it more convenient to manage different types of databases. Friends who like it might as well download it.

  2022-06-01 18:20:24 Views: 236
• 

  Mysql to re-query the data in the table

  1. Distinctselect count (distinct CName) from tebleselect count (CName) from (select distinct CName fro

  2022-06-01 18:20:23 Views: 290
• 

  Linux command: RPM

  Introduction to the RPM command: the full name of RPM is "RedHat Package Manager" and the abbreviation is RPM. RPM is a set of management programs that install the packages you need into your Linux host in the form of database records. 1. Fate

  2022-06-01 18:20:23 Views: 286
• 

  Install PostGIS-2.1.8

  Version: proj-4.8.0.tar.gzgeos-3.4.2.tar.bz2gdal-2.0.1.tar.gzPostGIS-2.1.82.1.8 prerequisite: proj,g must be installed before installing PostGIS

  2022-06-01 18:20:22 Views: 274
• 

  Detailed explanation of data Quick loading (dmfldr) in DM7 Database

  DM7 Database data Quick loading (dmfldr) detailed explanation 1.1 function dmfldr (DM Fast Loader) is a command line tool for fast data loading provided by DM7. By using the dmfldr tool, the user can click on a certain grid.

  2022-06-01 18:20:19 Views: 289
• 

  Use the logrotate tool to cut MySQL logs and send slow log analysis to mailboxes

  1. Install logrotate and percona-toolkityum install logrotate-yyum install https://www.percona.com/redir/downl

  2022-06-01 18:19:49 Views: 240
• 

  Postgresq9.6 master-slave deployment

  Postgresq9.6 master-slave deployment experimental environment name IP system Master172.17.10.190Centos 6.5Slave172.17.10.189Centos 6.51.yun installation rpm-ivh h

  2022-06-01 18:19:49 Views: 214
• 

  50 suggestions for MongoDB developers Tip23

  This series of articles are translated from "50 Tips and Tricks for MongoDB Developers". I can't find the Chinese version for the time being. Anyway, I have been studying mongodb deeply recently, so I just want to translate it. On the one hand, strengthen yourself.

  2022-06-01 18:19:45 Views: 224
• 

  Management of users, permissions, roles and tablespaces in Oracle topic 2

  1. Log in to Oracle with system users. Only legitimate users can access the Oracle database. Oracle default system users: sys/system, sysman, scott. A, system user description sys: this account is equivalent to SQL s

  2022-06-01 18:19:45 Views: 217
• 

  Index Series 6-- Verification experience of low height of Index characteristics

  Sqlplus ljb/ljbdrop table t1 purge;drop table t2 purge;drop table t3 purge;drop table t4 purge;drop

  2022-06-01 18:19:45 Views: 262
• 

  Getting started with MongoDB 3 music-updating documents and modifiers 1

  We talked about the CRUD operation of MongoDB earlier: the update operation of MongoDB is implemented through the update () function of the collection. This function takes two parameters: the document to be changed and what it looks like after the change. There are two ways to update a document: update the document and change some parts of the document

  2022-06-01 18:19:45 Views: 221
• 

  The platform grid part deletes the selection row

  Delete the grid part selection row without deleting the data in the database. You need to check the "allow multiple selections" property of the grid widget to delete multiple rows; press the Ctrl key when you select multiple data. Create a new form, bind the read-only business table, and add a "delete selected row data" function to the form function management.

  2022-06-01 18:19:43 Views: 280
• 

  Postgres database startup parameters

  SIGTERM no longer allows new connections, but allows all active sessions to complete their work normally, closing only after all sessions have finished their tasks. This is a smart turn off. SIGINT no longer allows new connections, send SIGTERM to all active servers (have them immediately

  2022-06-01 18:19:43 Views: 267