NAV: SLTechnology News&Howtos > Database >

• 

  Oracle data Table object

  Represents the very important data objects in the oracle database, but also the main objects, today, start to learn the management of tables! 1: data type of the table 1: character type CHAR: string of fixed character length (fast query) vachar2: variable length string field (section

  2022-06-01 18:07:10 Views: 248
• 

  Oracle11G_ logical backup

  Backup classification: physical backup (backup of database files, log files, control files, etc.), logical backup (backup of database logical components, such as tables, views, stored procedures, etc.); physical backup is more complex; fault classification: 1 statement failure, which is automatically handled by oracle server-side programs.

  2022-06-01 18:07:10 Views: 201
• 

  Mysql database backup

  Database backup 1 cold backup (cp) 2 LVM snapshot backup lvcreate-s-n rhel6node1-L 2G / dev/vg_kvm/rhel6base3 hot backup mysqldump-hserip-u

  2022-06-01 18:07:09 Views: 216
• 

  Display effect of field options in platform database

  The field of the platform database table, which supports single and multiple selections. The presentation style can be set to drop-down selection and plane selection. Drop-down selection: refers to the opening of the form, or new editing form, do not see the contents of the options, you need to go to the drop-down to view, and then select the desired options. Plane selection: refers to

  2022-06-01 18:07:09 Views: 265
• 

  Oracle ORA-32004 processing

  SYS AS SYSDBA@ORCL > startup open;ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS i

  2022-06-01 18:07:08 Views: 246
• 

  The operation of adding, deleting, changing and searching mongodb

  This article uses the example code to show the addition, deletion, modification and search operation of mongodb. The code is very detailed, which can be used as a reference for interested friends. I hope it will be helpful to you. Add: insert introduction: mongodb stores documents. The document is in json format.

  2022-06-01 18:07:08 Views: 295
• 

  Zabbix3.2.1 email alarm

  The zabbix monitoring server and client have been deployed, the monitored host has been added, and Zabiix monitoring is running normally. An email alarm is set on the Zabbix server. When the monitored host goes down or reaches the trigger preset value, it will automatically send an alarm email to the specified mailbox. Concrete

  2022-06-01 18:06:47 Views: 242
• 

  How to check whether the table is locked in mysql

  This article mainly tells you briefly how to check whether the table is locked in mysql. You can check 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 how to check whether the table is locked in mysql can bring you

  2022-06-01 18:06:47 Views: 211
• 

  MongoDB lookup data base

  Use the library database use libraray to view available databases and the collection show dbs show collections insert data insert operation to define the format of the document: document = ({"Typ

  2022-06-01 18:06:46 Views: 218
• 

  Resolution of bash:$'\ r': command not found error report

  First install yum-y install dos2unix to convert dos2unix aaa.sh (script name) source aaa.sh.

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

  Detailed introduction of three replication mechanisms in mysql: asynchronous replication, semi-synchronous replication and parallel replication

  Next, let's learn about the three replication mechanisms in mysql: asynchronous replication, semi-synchronous replication and parallel replication. I believe you will benefit a lot after reading it. There are not many words in the text. I hope that the three replication mechanisms in mysql will replicate asynchronously, semi-synchronous replication and parallel replication. **

  2022-06-01 18:06:46 Views: 225
• 

  Tutorials for installing Navicat for MySQL tools

  The following is a tutorial on the installation of Navicat for MySQL tools. The secret of the text is that it is close to the topic. So, let's not talk about gossip. let's just read the following. I'm sure you will after reading the tutorial on the installation of Navicat for MySQL tools.

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

  10 minutes to complete the MySQL physical xtrabackup incremental backup

  In the production environment, we usually take mysqldump full database backup, but this is not available for large databases, because mysqldump is a logical backup and the efficiency of backup and recovery is slow. If a critical value is given according to personal experience, databases below 50G can use my.

  2022-06-01 18:06:41 Views: 217
• 

  Four default databases for mysql 8.0

  After the installation of mysql 8.0, four databases are automatically generated information_schemaNFORMATION_SCHEMA provides access to database metadata, information about the MySQL server, such as database or table names, columns

  2022-06-01 18:06:25 Views: 291
• 

  Three properties of MySQL database

  What are the three properties of the MySQL database? In general, people's understanding of MySQL may stay at the conceptual level, while the understanding of the three major attributes of MySQL database is relatively less. Today I'm going to talk to you about the three attributes of MySQL database. 1. Atomicity, which requires that the attribute has the original.

  2022-06-01 18:06:25 Views: 258
• 

  How to use MySQL binary Log

  This article shares with you how to use MySQL binary logs. Using binary logs can achieve remote disaster recovery backup, read-write separation, data recovery and other functions. Through the summary of this article, I hope you can learn to use MySQL binary logs. Open bin-log log My

  2022-06-01 18:06:22 Views: 238
• 

  What are the advantages of mysql

  The following brings you about the advantages of mysql, 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 believe you will gain something after reading the advantages of mysql. 1. Fast running speed and small MySQL size

  2022-06-01 18:06:19 Views: 254
• 

  Reconfigure MySQL in a minute

  Let me tell you a little bit about reconfiguring MySQL in one minute. Have you ever heard of similar topics before? If you are interested, let's take a look at this article. I believe it will be more or less helpful to reconfigure MySQL after reading it in one minute. 1. Reconfigure MySQ

  2022-06-01 18:06:18 Views: 204
• 

  PostgreSQL OTL access

  By installing the PostgreSQL ODBC driver, and then access the database code void TestByOtl () {odbc::otl_connect db;odbc::otl_connect::otl through OTL

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

  The standby database flashed back to the day before to retrieve the mistakenly deleted data.

  Because the developer deleted a piece of data at 4: 00 a.m. on July 9, now there is a problem with the transaction. You need to check the status of the data at that time. The history table does not store this data. Now use the standby database to flash back to the point in time before deletion to retrieve the data. At that time, there was no record of the operation, so only the operation process was written. 1. View

  2022-06-01 18:06:18 Views: 258