NAV: SLTechnology News&Howtos > Database >

• 

  MySQL data operation

  -- insert information-- method 1 insert.. valueshouse-single statement insert into table name values (data); eg:insert into class values (21403001)

  2022-06-01 07:04:42 Views: 246
• 

  [MySQL] deadlock case 6

  Deadlock is actually a very interesting and challenging technical problem, which probably every DBA and some developers will encounter in the course of their work. I will continue to write a series of case studies on deadlocks, hoping to be helpful to friends who want to know about deadlocks. Case study 2.1

  2022-06-01 07:04:41 Views: 257
• 

  What is SQL injection (SQLi)

  What is SQL injection? SQL injection (SQLi) is generally thought of as an injection attack in which an attacker can execute malicious SQL statements. It controls the database server of the Web application. Due to the helplessness of SQL injection, it may affect any use of SQL-based databases

  2022-06-01 07:04:41 Views: 293
• 

  Basic concepts of RBO and CBO

  Transferred from the source of Xiaoxiang hermit: the optimizer in http://www.cnblogs.com/kerrycode/p/3842215.htmlOracle database is also called query optimizer (Query Optimizer). It's SQL.

  2022-06-01 07:04:37 Views: 228
• 

  Summary of simple knowledge and orders for MySQL interview

  For children's shoes interviewing for MySQL positions, most interviewers will test the following simple MySQL knowledge and commands: 1. How to determine whether MySQL starts and how to start and shut down MySQLservice mysql status/star

  2022-06-01 07:04:36 Views: 262
• 

  CentOS 6.6 install single node Redis 3.0.3

  1. Download redis-3.0.3 and extract # cd / usr/local# wget http://download.redis.io/releases/redis-3.0.3.tar.gz# tar-

  2022-06-01 07:04:36 Views: 248
• 

  CentOS 7 installs Oracle 11.2.0.4

  This article is reproduced from: https://www.cnblogs.com/xqzt/p/5456401.html, but combined with the actual situation, the content has been slightly changed. First, the installation environment CentOS Linux release 7.2.1511

  2022-06-01 07:04:08 Views: 243
• 

  A detailed explanation of the usage of Ajax in jQuery Learning Notes

  This article mainly introduces the Ajax usage of jQuery learning notes. The construction of Changsha website, combined with the form of examples, analyzes and summarizes the relevant skills of using ajax in jQuery, including ajax request, loading, processing, transmission and so on. Friends in need can refer to this article.

  2022-06-01 07:04:01 Views: 270
• 

  [Mysql] metadata lock lock

  Original address: the timeout of http://blog.itpub.net/26250550/viewspace-1071987/metadata lock is lock_wait_timeout, not innodb

  2022-06-01 07:04:01 Views: 291
• 

  ORACLE 12C DATAGUARD environment building and master-slave switching

  Environment description: objective: (1) to create an oracle 12c single instance dataguard environment under the linux operating system (2) to test the dataguard master-slave switching master library: 10.50.115.12 (DB_UNIQUE_NAM)

  2022-06-01 07:04:00 Views: 234
• 

  MySQL 5. 7 Invalid default value for & # 039; the solution to error reporting

  Due to the upgrade of the database, today I am executing the SQL file exported from MySQL 5.6.Times error: mysql > source cms_user.sqlQuery OK, 0 rows affected (0.00 sec) Q

  2022-06-01 07:03:57 Views: 227
• 

  Rule processing of distributed cache load balancing: improvement of consistent hash in virtual nodes using fixed hash algorithm to balance load

  In the large-scale cache application, the distributed cache system arises at the historic moment. How is key-value evenly distributed into the cluster? The most conventional way is to take the mold by hash. For example, if the appropriate number of machines available in the cluster is N, then the data request with a key value of K should simply be routed.

  2022-06-01 07:03:57 Views: 242
• 

  Orm detailed explanation

  Blog park home page blog ask flash new essay subscription management ORM: (in django, automatically generate database tables according to the classes in the code is also called-- code first) ORM:Object Relational Mapping (relationship

  2022-06-01 07:03:28 Views: 249
• 

  Introduction to MySQL-- Master-slave replication of MySQL replication Technology

  MySQL replication technology: master and slave establish the most basic replication in MySQL, which can be summarized into the following three steps: 1. Configure a server as Master;2. Configure a server as Slave;3. Connect Slave to Master.1)

  2022-06-01 07:03:28 Views: 214
• 

  Some tips on pager and other commands in mysql

  one。 Pager less or pager more description: less mode, you can use the space to the next page, Q exit; more mode, like the linux more command, press the space to display to the next page, for example: mysql > pager less

  2022-06-01 07:03:27 Views: 270
• 

  11G GI installation runs script test at the same time

  Problem: 11G takes a long time to execute the second script, and the test results of the two machines running the script at the same time: cannot be executed at the same time, but must be executed in turn. The simultaneous execution of the second script will lead to failure due to disk contention. ASM SID will be the first node where the second script is executed first, not because of environment variables.

  2022-06-01 07:03:25 Views: 235
• 

  Undo tablespace capacity

  Check the use of the tablespace SELECT a.tablespaceroomname _ name _ circle (a.total_size) "total_size (MB)", ROUND (a.total_size)-ROUND

  2022-06-01 07:03:25 Views: 232
• 

  Oracle activity session History (ASH) and report interpretation

  The real-time monitoring of various states during the operation of the database and the capture of related performance data are very important to solve the performance problems and improve the running efficiency of the overall business system. In Oracle database, the real-time capture of relevant performance data is realized by ASH tools. ASH passes every second

  2022-06-01 07:03:23 Views: 244
• 

  Oracle 11g RAC + DG installation details-04

  6. Verify 1. Start em verification 2. Log in to sqlplus to check [oracle@TRAC1 ~] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Prod

  2022-06-01 07:03:19 Views: 271
• 

  The market environment of third-party payment

  The history of the development of numerous industries shows that in order to support the development of a certain industry, the initial state always provided it with a relaxed environment, and even turned a blind eye to some acts of scraping the edges and exploiting loopholes in policies. however, to a certain extent, especially in the period of rapid development, the relevant state departments will intervene in the management and mention.

  2022-06-01 07:03:16 Views: 229