NAV: SLTechnology News&Howtos > Database >

• 

  Resolve database Bug:RVWR TERMINATES INSTANCE IF FRA IS FULL

  1. Database version Oralce 12c 12.1.0.2 when running out of FRA space, the database will automatically turn off flashback. The instance will not down. This BUG has been solved. * *

  2022-06-01 18:55:46 Views: 211
• 

  Postgresql inserts Chinese characters and reports errors

  Error message: peimsmdb=# select'I'; ERROR: character with byte sequence 0xe6 0x88 0x91 in encoding "UTF8" has

  2022-06-01 18:55:46 Views: 213
• 

  Detailed operation of forum migration of production environment website

  First, find the previously installed Discuz installation directory on the server and copy it to the Web installation directory, and rename cd / usr/local/src/cp-r upload / home/WebSer/mv upload bbs.lh

  2022-06-01 18:55:41 Views: 275
• 

  How to install and configure mysql8.0 in centos7 system

  The following mainly brings you how to install and configure mysql8.0 on the centos7 system. I hope these contents can bring you practical use, which is also the main purpose of this article on how to install and configure mysql8.0 on the centos7 system. All right, no more nonsense, everybody.

  2022-06-01 18:55:41 Views: 269
• 

  What's the difference between BYTE and CHAR in Oracle?

  Oracle defines string types VARCHAR2 and CHAR the use of the specified length is as follows: varchar2 () is a number between 1 and 4000, indicating a maximum of 4000 bytes of storage space. Char () is between 1 and 2000.

  2022-06-01 18:55:41 Views: 209
• 

  Introduction to the function of zabbix configuration file

  Configuration file type zabbix_server profile: zabbix_server.confzabbix_proxy configuration file: zabbix_proxy.confzabbix-agentd configuration file: zabb

  2022-06-01 18:55:41 Views: 236
• 

  How to install oracle without filling in hosts resulting in pop-up window error

  The following error pops up in the installation interface when oracle is installed. This is because the hostname is not set in the hosts file. Because I do not have a screenshot when I operate it, I would like to share with you a tutorial on the Internet directly, and the content has been modified. Run. / runIn

  2022-06-01 18:55:40 Views: 251
• 

  Several common simple commands for managing Mysql database

  This article mainly introduces several common simple commands for managing Mysql database. The content of the article is carefully selected and edited by the author. It has a certain pertinence and is of great significance to everyone's reference. Let's learn about some common simple commands for managing Mysql database with the author.

  2022-06-01 18:55:15 Views: 278
• 

  Summary of some problems of mysql5.7 character set

  This article mainly gives you a brief introduction to some problems of the mysql5.7 character set. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on the mysql5.7 character set can give you some information.

  2022-06-01 18:54:52 Views: 286
• 

  Introduce the knowledge of MySQL database index in detail

  The following is about the knowledge of MySQL database indexing. The secret of the text lies in being close to the topic. So, no gossip, let's read the following directly, I believe you will benefit from reading this article on MySQL database indexing knowledge. MySQL database-index 1

  2022-06-01 18:54:52 Views: 258
• 

  A simple understanding of indexes, transactions and views in Mysql

  Let's learn about the index, transaction and view in Mysql. I believe you will benefit a lot after reading it. The text is not very good. I hope the index, transaction and view in Mysql is what you want. The conceptual index of an index is a special file that contains all the data in the data table

  2022-06-01 18:54:52 Views: 262
• 

  How to diagnose the fault point and recover the data when there is a problem between the master and slave of mysql

  This article mainly introduces how to diagnose the fault point and recover the data after the mysql master-slave problem arises. The content of the article is carefully selected and edited by the author, which has a certain pertinence and is of great reference significance to everyone. Let's work with the author to understand what should be done after the mysql master-slave problem occurs.

  2022-06-01 18:54:51 Views: 283
• 

  How to use function in MySQL Multi-table query

  The following mainly brings you how to use functions in MySQL multi-table queries. I hope these contents can bring you practical use, which is also the main purpose of this article on how to use functions in editing MySQL multi-table queries. All right, don't talk too much nonsense, let's just read the following. 1. Multi-table combination check

  2022-06-01 18:54:51 Views: 207
• 

  How to deal with exceptions in MySQL stored procedures

  Let's learn how to deal with exceptions in MySQL stored procedures. I'm sure you will benefit a lot after reading it. There are not many words in the text. I hope you want this short article on how to deal with exceptions in MySQL stored procedures. Experimental environment: mysql > use TENN

  2022-06-01 18:54:50 Views: 277
• 

  How does mysql use functions to intercept strings?

  First we need to understand the string interception functions: left (), right (), substring (), substring_index (). And mid (), substr (). Where mid (), substr (

  2022-06-01 18:54:50 Views: 236
• 

  Self-taught MySQL custom function

  Let's talk about MySQL custom functions. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on MySQL custom functions. 1. Introduction to custom functions: user-defined functions (

  2022-06-01 18:54:49 Views: 238
• 

  How does the mysql database add users and authorize them?

  Query all user modes: 1:mysql > select host, user, password from mysql.user;-- mysql > select before version 5.7

  2022-06-01 18:54:44 Views: 201
• 

  How to annotate mysql datasheets and fields?

  Specific steps for mysql to create tables with explanations and add comments to tables and fields: 1. Create tables with explanations CREATE TABLE test_table (t_id INT (11) PRIMARY KEY AUTO_INCREMEN)

  2022-06-01 18:54:44 Views: 234
• 

  How does mysql enable slow log?

  First of all, we need to know four parameters: whether slow_query_log # enables slow log, the default is OFF, and if enabled, it is set to ON. Slow_query_log_file # slow query log file storage location. Log_querie

  2022-06-01 18:54:43 Views: 229
• 

  Mysql5.7 forgot how to change the root password

  This article is mainly to tell you briefly how mysql5.7 forgot to change the root password. You can check the relevant technical terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope mysql5.7 forgets how to change the root password.

  2022-06-01 18:54:41 Views: 219