NAV: SLTechnology News&Howtos > Database >

• 

  Basic operation of mysql database 1

  Mysql database management day01 related concepts database introduction? Which companies are using warehouse database services for storing data? What data is stored in the shopping website, the game website, the financial website, the data service? The data information corresponding to the account information provides database service software

  2022-06-01 17:33:38 Views: 273
• 

  Mysql cannot connect to the solution remotely

  Preface Mysql version: 5.7.23 operating system: Linux problem description: only through the Linux system account Root command line to enter the database, can not use JDBC, remote connection tools to enter the database. Error: ERROR 1698 (28000)

  2022-06-01 17:33:23 Views: 238
• 

  Mysql-5.6.26 master master replication

  The environment is as follows: CentOS6.5_64MySQL5.6.26master1:192.168.1.112master2:192.168.1.114mysql installation is ignored here, mainly as a matter of care. Sometimes one doesn't.

  2022-06-01 17:33:23 Views: 211
• 

  Initial deployment of Hibernate

  Download the full set of files: hibernate-release-4.1.7.Final.zip directory structure under the Documentation folder is the development help documentation Lib folder is the library used by the development, including the required under this folder

  2022-06-01 17:33:23 Views: 242
• 

  Install MongoDB on Linux platform

  MongoDB provides 64-bit installation packages for all linux distributions, which you can download from the official website. Download address: under https://www.mongodb.com/download-center#community

  2022-06-01 17:33:23 Views: 278
• 

  Database Design (1)-- Database Design

  Database design (1)-- introduction to database design according to the specification, the design process of the database is divided into six stages: a, system requirement analysis stage B, conceptual structure design stage C, logical structure design stage D, physical structure design stage E, database implementation stage F, data.

  2022-06-01 17:33:19 Views: 234
• 

  The difference between backquotation marks and single quotation marks in Mysql

  This article shares with you the difference between backquotes and single quotes in Mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look. Backquotation marks, usually below the ESC key. It was introduced to distinguish reserved words from ordinary characters in MYSQL.

  2022-06-01 17:33:18 Views: 250
• 

  12c New feature-Unified Audit (Unified Auditing)

  Database version 12.1.0.2 production environment can turn off this feature. 1. Turn off unified audit SYS@orcl1 > SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unifie by default

  2022-06-01 17:33:18 Views: 273
• 

  Oracle implements function-based indexing

  Usage scenario: when a query runs slowly. By examining the where clause, it is found that the sql lower function is applied to one of the columns, and the lower function prevents the use of existing indexes on that column. You want to create a function index to support this query, as follows: SQL > sel

  2022-06-01 17:33:18 Views: 207
• 

  EBS uses API to update material properties Inv_Item_Grp

  Using standard API Inv_Item_Grp to update material properties, you can modify most of the fields, including item code, item description, and so on. Unmodifiable fields: PRIMARY_UNIT_OF_MEASURE, TRACKING_QUANTI

  2022-06-01 17:33:17 Views: 231
• 

  [beginner's Guide] create a GridView in ASP.NET MVC 5

  In this article, we will learn how to create a gridview in ASP.NET MVC, just like gridview in an ASP.NET Web form. There are many third-party libraries available on both the server side and the client side, these libraries

  2022-06-01 17:33:01 Views: 247
• 

  The solution to the inconsistency between MySQL slow query log time and system

  How to solve the difference of 8 hours between MySQL slow query log time and system time? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. When looking at the slow query, I found that the time was not right.

  2022-06-01 17:32:57 Views: 288
• 

  What are the query selectors of mongodb

  What are the query selectors for mongodb? To solve this problem, today the editor summarizes this article about mongodb's query selector, hoping to help more friends who want to solve this problem to find a more simple and easy way. Query selector: $eq matches a value equal to the specified value.

  2022-06-01 17:32:57 Views: 253
• 

  Brief Analysis of HBase Client API

  I watched HBase's Client API in 2 hours on the plane yesterday, and I learned a few things: 1. It is best to close autoFlush and set WriterBuffer reasonably when Put Mini record: because every time Put makes a RPC call + W

  2022-06-01 17:32:57 Views: 262
• 

  Detailed introduction of mycat configuration file

  The main purpose of this article is to share the configuration file of mycat. This paper also introduces the calculation process and usage of several slicing algorithms commonly used in mycat. I hope you can get something through this article. The relationship between common configuration files can be seen from the above figure of the core configuration file of Mycat

  2022-06-01 17:32:56 Views: 255
• 

  The use of cursors in oracle

  1)-use cursors with parameters; declareCURSOR stock_cur (symbol_in VARCHAR2) ISSELECT * FROM rate_combine_nr nr WHERE

  2022-06-01 17:32:55 Views: 277
• 

  Usage of HBase Filter (1)

  1. FilterList / / by setting the operator parameter to Operator.MUST_PASS_ONE, the or / / default operator parameter of the relationship where each filter is "or" in list is set to

  2022-06-01 17:32:55 Views: 216
• 

  Oracle imports data from one user to another (data pump)

  192.168.0.1--server11. Before using expdp to export data [expdp version], you need to build directory1 and create directory dump as'/ u0 in Oracle now.

  2022-06-01 17:32:55 Views: 225
• 

  Separation of read and write by mysql+mycat

  The centos7masterslavemycat1.6client192.168.41.10192.168.41.11192.168.41.12192.168.41.13 lab environment closes its own firewall configuration for all

  2022-06-01 17:32:43 Views: 289
• 

  How to deal with deadlocks found in the database of the operating system

  Where q.address = s.sql_addressand q.hash_value = s.sql_hash_valueand s.paddr = p.addrand exists (se

  2022-06-01 17:32:43 Views: 273