NAV: SLTechnology News&Howtos > Database >

• 

  The method of modifying File size limit by phpmyadmin

  In this issue, the editor will bring you the method of modifying the file size limit of phpmyadmin. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. The problem encountered when the website moved, because the data has been

  2022-06-01 14:27:18 Views: 268
• 

  MySQL log management

  1. Four kinds of logs 1. Error logs: record the startup, operation and shutdown process of the mysql server. By default, mysql > show variables like 'log_error';2 ends with .err, and the binary log records user-to-data.

  2022-06-01 14:27:17 Views: 234
• 

  Comparison of several methods for Segmentation of string

  In database development, it is sometimes encountered that strings are divided according to certain rules, such as "a string with a comma as a delimiter, such as" a memeb, pencycline, parenthetics, and so on, which need to be separated, and then separate into a line. The first thing that comes to mind is to use the substitution function to remove the delimiter. So there is.

  2022-06-01 14:27:17 Views: 219
• 

  Performance Optimization of Oracle Learning (11) materialized View

  Materialized view is mainly used to pre-calculate and save the results of more time-consuming operations such as table join or aggregation, so that when executing the query, we can avoid these time-consuming operations and get the results quickly. Query rewriting (query rewrite) machines are also often used in data warehouses

  2022-06-01 14:27:17 Views: 300
• 

  SQLServer 2012 create a new read-only account for a specific table

  Set up a read-only account and can only read certain tables. Now let's share the steps of the operation with you. The premise of this operation is that the database is relatively large, there are many data tables, and you need to select your own read-only data tables. The operation of the new account should be no stranger, so I'll give you a screenshot and don't talk about it. On the left

  2022-06-01 14:27:08 Views: 275
• 

  Performance Optimization of Oracle Learning (4) collecting Statistical Information

  The emp table has the following data. SQL > select ename,deptno from emp;ENAME DEPTNO-

  2022-06-01 14:26:55 Views: 301
• 

  Recovery of Bad Block based on rman

  Reprint, please indicate the source of http://blog.csdn.net/guoyjoe/article/details/30965303 experiment steps are as follows: 1. Use rman to back up the whole library Recovery Manager: Re

  2022-06-01 14:26:43 Views: 260
• 

  Mysql specifies the storage directory when creating the table

  1. Check to see if using symbolic links SHOW VARIABLES LIKE 'have_symlink';2. Open symbolic link support to open vi / etc/my.cnf and change it to symbolic-links=13. Set m

  2022-06-01 14:26:43 Views: 255
• 

  Solve the problem of Null when querying the database (such as SUM function)

  Select ISNULL (sum (field), 0) from tableName

  2022-06-01 14:26:43 Views: 250
• 

  Related design of mongodb comment reply

  Works and comments can be designed as a collection, comments as subdocuments are embedded in the comments attribute of art, and responses to comments are embedded in the replies attribute as subdocuments of comment subdocuments. According to this design pattern, you only need to follow the work

  2022-06-01 14:26:39 Views: 293
• 

  Oracle changes username and password

  After the ORACLE database is copied or cloned, it is often necessary to change the user name and password. The following methods and steps are summarized: 1. Query the system table USER$SELECT NAME,USER# FROM user$ WHERE UPPER (TRIM)

  2022-06-01 14:26:39 Views: 294
• 

  MySQL Storage engine and Lock

  MySQL Storage engine and Lock = = Storage engine: 1. Introduction

  2022-06-01 14:26:39 Views: 213
• 

  Oracle11g installation script

  #! / bin/baship=ifconfig | grep 'inet addr:' | grep-v' 127.0.0.1'| cut-d:-f2 | awk'{print $1} 'hostname=

  2022-06-01 14:26:38 Views: 201
• 

  DB2 installation and deployment and application deployment configuration operations

  At the end of the year, the company needs to deploy a set of DB2 environment + application system to demonstrate related functional modules to customers. Before, there is not much contact with DB2. Take advantage of this opportunity to open the road of exploration and learning of DB2. DB2 database deployment hardware environment information: machine IP:10.1

  2022-06-01 14:26:38 Views: 280
• 

  Sql query email address multiple lines merge one line, and then send mail

  -- create test table use FlygoIF OBJECT_ID ('test') IS NOT NULL DROP TABLE testCREATE TABLE test (Id int IDEN)

  2022-06-01 14:26:38 Views: 287
• 

  New feature of Oracle 11g: read-only meter (Read-only)

  Oracle11g has introduced a new feature that allows table to be placed in the read only state, where table cannot perform DML operations and some DDL operations. In previous versions of Oracle11g, you could only use the entire tablespa

  2022-06-01 14:26:38 Views: 236
• 

  Navicat usage tutorial: automating Database replication with Navicat Premium 12 (1)

  Download the latest version of Navicat Premium Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases in a single program at the same time.

  2022-06-01 14:26:25 Views: 300
• 

  Install vCenter5.1 using the oracle database

  Background shows that a customer's site environment is a virtualized platform composed of 9 servers, of which one physical server installs vCenter 5.1 and oracle 11g R2 databases, and the other 8 compose Cluster to be managed by vCenter. VCent is described below.

  2022-06-01 14:25:55 Views: 272
• 

  Compilation and installation of zabbix and Wechat alarm

  Recently changed jobs, there are still a lot of things to do at the beginning, now make a summary and share with you. On the first day of joining the new company, the department leader assigned the task, arranged a set of zabbix monitoring system, monitored the company's firewall, switch and all online servers, and then called Wechat.

  2022-06-01 14:25:55 Views: 250
• 

  Design principles of Hbase watches

  1. The design of column clusters should be as few as possible, preferably no more than 3. Because each column cluster exists in a separate HFile, flush and compaction operations are carried out for a Region. When a lot of data in a column cluster needs flush, the other

  2022-06-01 14:25:55 Views: 264