NAV: SLTechnology News&Howtos > Database >

• 

  The column format of oracle causes the field value to be displayed as & quot;####"

  Problem: when querying a certain field, the result field values are all "#" reason: when doing other queries before, the same field name is formatted: col value format A20, so the column data display is abnormal; solution: 1. Exit the current

  2022-06-01 18:32:48 Views: 295
• 

  Snapshot backup for Oracle 11g physical dataguard

  It is still very tedious to prepare a read-write backup database in oracle 10g. After preparing the dataguard, you have to manually create a restore point, manually stop log transmission, manually activate and force to open it, and finish the test. If the SCN difference between the master and backup is too much, you still have to do incremental backup and statistics.

  2022-06-01 18:32:48 Views: 236
• 

  Mongodb Export Import

  Databases are divided into cold backup and hot backup, the so-called cold backup is to stop the library, and then copy the data; hot backup is to use the corresponding tools to do backup while the database is running. Each library has its own hot backup tool, and mongodb is no exception. The backup of mongodb mainly includes hot backup and cold backup.

  2022-06-01 18:32:47 Views: 282
• 

  How to adjust the character set of MySQL data Table

  Let's learn how to adjust the MySQL data table character set, I believe you will benefit a lot after reading, the text is not much in the essence, hope that how to adjust the MySQL data table character set this short content is what you want. Structure of data table T1 table. MySQL > show crea

  2022-06-01 18:32:43 Views: 230
• 

  Windows installs mysql8.0.12 using the zip package

  1. Preface there are two ways to install mysql under windows, one is the way of msi, the other is the installation mode of using zip package. Usually use the msi way, after all, do not need to type the command, only the graphical interface can be completed. The installation of the zip package is also simple.

  2022-06-01 18:32:43 Views: 263
• 

  Forget how to log in with mysql's password

  The following is about how to log in when you forget your mysql password. 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 that you forget how to log in with your mysql password. 1. If the database is logged into linu for the first time

  2022-06-01 18:32:43 Views: 270
• 

  Using mysqldump to realize the practice of mysql backup

  This article mainly introduces the practice of using mysqldump to achieve mysql backup. 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 using mysqldump to implement my.

  2022-06-01 18:32:43 Views: 294
• 

  What is the data type of MySQL

  I don't know if you have any knowledge of similar articles about what is the data type of MySQL. Today, I'm here to tell you a little bit about it. If you are interested, let's take a look at the text. I'm sure you'll get something after reading what the data type of MySQL is. 1. Overview: MySQ

  2022-06-01 18:32:42 Views: 277
• 

  Knowing the main 10 sentences of Mysql for the first time

  Below to bring you the main 10 sentences of Mysql related content, I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the text. I'm sure you'll get something after reading the 10 main sentences of Mysql. 1. View the current CVM

  2022-06-01 18:32:42 Views: 238
• 

  How to insert, delete and update statements in Mysql database

  The following brings you about how to insert, delete, update statements in the Mysql database, if you are interested, let's take a look at this article. I believe it is more or less helpful for you to read how to insert, delete and update statements in the Mysql database. The brief introduction is opened by MySQL AB Company.

  2022-06-01 18:32:41 Views: 257
• 

  How to install MySQL on unix/linux using binaries

  Let me tell you a little bit about how to use binaries to install MySQL on unix/linux. Have you known about similar topics before? If you are interested, let's take a look at this article. I believe that after reading the binaries in unix/linux

  2022-06-01 18:32:41 Views: 287
• 

  Combine binlog log to realize backup and restore of mysqldump

  This article is mainly about the implementation of mysqldump backup and recovery combined with binlog logs. If you are interested, let's take a look at this article. I believe it will give you some reference for mysqldump backup and recovery after reading it combined with binlog logs.

  2022-06-01 18:32:40 Views: 242
• 

  What if the application cannot connect due to improper setting of MySQL database parameters

  This article mainly gives you a brief account of what to do if the application cannot be connected due to improper setting of MySQL database parameters. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. We hope that improper setting of MySQL database parameters will lead to

  2022-06-01 18:32:40 Views: 243
• 

  How to build MySQL Master-Slave replication based on Docker

  The following is mainly about how to build Docker-based MySQL master-slave replication. I hope these contents can bring you practical use, which is also the main purpose of my editor how to build Docker-based MySQL master-slave replication. All right, let's cut the crap and let's go straight.

  2022-06-01 18:32:30 Views: 208
• 

  How to check the number of threads in MySQL

  Let's learn how to check the number of threads in MySQL. I believe you will benefit a lot after reading it. The text is not much in essence. I hope you want to see how to view the number of threads in MySQL. Mysql restart command: / etc/init.d/mysql re

  2022-06-01 18:32:29 Views: 210
• 

  What are the ways to add mysql foreign keys

  This article mainly introduces to you what methods can add mysql foreign keys, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand what methods can add mysql foreign keys bar. Mysql

  2022-06-01 18:32:29 Views: 280
• 

  The safest way to set up a MySQL database

  Let's talk about the safest way to set up a MySQL database. The secret of the text is to be close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on the safest way to set up a MySQL database. 1. Modify the root account

  2022-06-01 18:32:29 Views: 223
• 

  Introduction of PXC Cluster in MySQL

  First, PXC introduction reference: Percona official PXC is an open source MySQL high availability solution, which integrates Percona Server and Xtrabackup with Galera libraries to achieve synchronous multi-master replication. Gao Ke based on Galera

  2022-06-01 18:32:26 Views: 254
• 

  Steps to successfully install MySQL5.7.13

  Below to bring you a successful installation of MySQL5.7.13 steps related to the content, I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the body. I'm sure you'll get something after reading the steps to successfully install MySQL5.7.13. Installation

  2022-06-01 18:32:26 Views: 219
• 

  [theoretical research] basic knowledge and principles of database series 01-basic principles and

  Database as the most frequently used middleware, as an IT engineer, even if he does not intend to engage in database development or DBA, he should master its basic knowledge, principles and basic use. To this end, at the beginning of this article, try to explain the basic knowledge and principles of the database. Type relation of database

  2022-06-01 18:32:25 Views: 235