NAV: SLTechnology News&Howtos > Database >

• 

  The method of inserting data in batch with insert statement in mysql

  This article will explain in detail the method of inserting data in bulk with insert statements in mysql. The content of the article is of high quality, so I will share it for your reference. I hope you can get something after reading this article. INSERT INTO statement is used to insert into a table

  2022-06-01 15:43:16 Views: 302
• 

  Installation and deployment of monitored cacti (monitoring local and other hosts + supporting multithreading + command line monitoring)

  Host environment redhat6.5 64-bit experimental environment server 1 ip 172.25.25.1 server 2 ip 172.25.25.2 installation package cacti-0.8.8h.tar.gzphp-snmp-5.3.3-2

  2022-06-01 15:42:46 Views: 265
• 

  A complete Collection of commonly used MySQL commands

  MySQL common commands 1. Mysql: connect to the database mysql commands users to connect to the database. Mysql command format: mysql-h host address-u user name-p user password 1) connect to the MYSQL on this machine first

  2022-06-01 15:42:46 Views: 227
• 

  Principle and Construction of MySQL Master-Slave replication

  one。 The working process of master-slave replication: 2.MySQL replication type based on SQL statement replication based on row replication hybrid replication III. The experimental environment is OS:CentOS 6.5 x64master:192.168.0.134slave:192.168.

  2022-06-01 15:42:43 Views: 230
• 

  Three modes of binlog

  The characteristics of three modes of binlog statement mode: (1) this mode does not support RU,RC isolation level; (2) the end point of the last thing in the binglog log file is the starting point of the next thing; (3) the DML,DDL statement will be clearly displayed; (4)

  2022-06-01 15:42:42 Views: 213
• 

  The usage of sqlldr

  Import the txt text method in the oracle database, such as now you need to import the data from t_user_mobile_list.txt into the oracle database tweak username mobile _ list table. 1. First, you need the ctl file ct.

  2022-06-01 15:42:38 Views: 222
• 

  The method of creating self-growing primary key by Oracle

  This article will explain in detail how to create a self-growing primary key in Oracle. The content of the article is of high quality, so I hope you can get something after reading this article. Steps for Oracle to create self-growth: create self-growth sequence-create self-increment

  2022-06-01 15:42:37 Views: 295
• 

  12c expdp ORA-31623-encountered BUG again

  1. Environment description 12.1.0.2 RAC 2. Detailed process yesterday did a 12c RAC environment expdp backup operation, the result is an error, check the official website is actually BUG. 1. Error message UDE-31623: operation gene

  2022-06-01 15:42:37 Views: 219
• 

  Two grammars of case when in MySQL

  In this issue, the editor will bring you two grammars about case when in MySQL, which will be analyzed and described from a professional point of view. I hope you can get something after reading this article. Usage of Case when: once a WHEN is satisfied, then

  2022-06-01 15:42:36 Views: 275
• 

  OpenStack Mirror Service Glance [3]

  OpenStack mirroring service Glance [3] OpenStack mirroring service Glance [3] openstack time: November 28, 2016 OpenStack mirroring service Glance introduction to create virtual machines we need

  2022-06-01 15:42:36 Views: 306
• 

  Redis startup script, boot automatically

  # chkconfig: 2345 90 10# description: Redis is a persistent key-value databasePATH=$PATH:/usr/local/

  2022-06-01 15:42:36 Views: 248
• 

  MongoDB Series-1 Windows installation MongoDB

  Windows installation MongoDB introduction: install MongoDB as a service environment for Windows: Windows 7 64 bit software: mongodb-win32-x86_64-2.2.2.zip (1) put m

  2022-06-01 15:42:28 Views: 228
• 

  How to use having in mysql Database

  In this issue, the editor will bring you about the use of having in the mysql database, analyze and describe it from a professional point of view. I hope you can get something after reading this article. The having sentence allows us to filter all kinds of data after grouping, where

  2022-06-01 15:42:28 Views: 263
• 

  How to optimize SQL statement

  This article uses easy-to-understand examples to introduce how to optimize SQL statements, the code is very detailed, interested friends can refer to, hope to be helpful to you. 1. Common SQL practices (1) negative conditional queries cannot use index select * from

  2022-06-01 15:42:27 Views: 202
• 

  Some STUFF commonly used in daily inspection and maintenance of Oracle

  Check the oracle version of select banner from sys.v_$version;-- to see the number of connections of different users select us

  2022-06-01 15:42:27 Views: 268
• 

  SQL basic sub-query, multi-table insertion, merge statements, tracking data changes over a period of time (20)

  Using subqueries to process data you can use data manipulation language (DML) statements in subqueries: use embedded views to retrieve data from one table to another to copy data from one table to another based on the value of another table to update the data in the table based on the value of another table to delete the exercise in the table use the subquery as the data source to retrieve the data sel

  2022-06-01 15:42:15 Views: 247
• 

  Removing weight and displaying Table structure of SQL Foundation (4)

  When we query through the select statement, we will find a lot of the same information, at this time we want to remove the duplicate information, what should we do? For example, there are repetitions like the following, here we can use distinct to re-assume that someone in the query department is working. It can also be passed.

  2022-06-01 15:42:07 Views: 240
• 

  RAC 11G R2 ORA-01078 ORA-01565 ORA-17503 ORA-12547 error

  The RAC test environment built a few days ago: oel6.7 grid and database are both 11.2.0.4.0. After rebooting today, one of the node databases can not start up, but the cluster can start normally. Manual startup error report: SQL > startup

  2022-06-01 15:42:06 Views: 228
• 

  MongoDB deletes the database

  Rszhou:PRIMARY > show dbsadmin 0.000GBlocal 146.588GBdb_chunqiu 1163.165GBrszhou:PRIMARY > use db_chunq

  2022-06-01 15:42:03 Views: 284
• 

  Database queries the sql of locked and unlocked tables

  When the program was running before, the page suddenly jammed and the background did not report an error. After investigation, the database table was locked. The following sql is to query the locked table, and the corresponding unlock sql;select b.ownerzhore b.objectwriter name.ses.

  2022-06-01 15:42:03 Views: 261