NAV: SLTechnology News&Howtos > Database >

• 

  Installation of MySQL and installation of tool Navicat for MySQL

  Installation of Navicat: method 1 official download installation package https://www.navicat.com.cn/download/navicat-for-mysql for Windows choose the version of 32bit or 64bit

  2022-06-01 11:17:37 Views: 232
• 

  [MySQL] mysqlbinlog_flashback tool use

  Introduction: mysqlbinlog_back.py is a tool to read the binlog of mysqld in row format online and then generate reverse sql statements. It is generally used for data recovery purposes. The so-called reverse sql statement is that if it is insert, then

  2022-06-01 11:17:36 Views: 289
• 

  [MySQL] simple command summary

  View database SHOW DATABASES; to create database CREATE DATABASE IF NOT EXISTS database name; select database USE database name; view data table in database SHOW TABLES; to delete data

  2022-06-01 11:17:23 Views: 252
• 

  Deploy SQL Server 2016 based on the workgroup's AlwaysOn AG

  Deployment of SQL Server 2016 is based on the workgroup's AlwaysOn AG deployment instructions: the following deployment is based on the workgroup environment, does not require a certificate, the startup account is a member of the Users group, and each node is located in the same network segment. Pre-environment preparation refers to the previous article: deploying Wind

  2022-06-01 11:17:23 Views: 286
• 

  Mysql View Modification

  First, view engine 1, view mysql engine 1SHOW ENGINES;2, view table engine, method 1: SHOW TABLE STATUS from database name where Name=' table name'; 1SHOW TABL

  2022-06-01 11:17:22 Views: 207
• 

  Cursor: pin S wait on X database is slow

  The application response says that the system is slow, the time is not fixed, the phenomenon is not known, it is slow. I have no choice but to log in to the system to check. View existing snapshot information on the system SQL > col mintime for a30SQL > col maxtime for a30SQ

  2022-06-01 11:17:10 Views: 255
• 

  ORA-1031 signalled during

  Error message: ORA-1031 signalled during: create tablespace tablespace name datafile'+ DATA' size 10m autoextend on next

  2022-06-01 11:17:10 Views: 276
• 

  SQL Server Import error: The LocaleID 4 is not installed on this system

  Problem description: import Chinese character set data through SQLServer Import and Export Wizard and encounter The LocaleID 4 is not installed on this system. Mistake. Solution: I found that the client-server operating system

  2022-06-01 11:17:10 Views: 279
• 

  Oracle 11g manually create the database (Linux platform)

  First, the environment Oracle 11g GUI platform II, suitable for scenarios in some cases can not provide Linux environment. Need to build the library manually: the operating system has installed the necessary packages and ORACLE software. 3. The process of building the library manually sets the environment variable .bash.

  2022-06-01 11:17:09 Views: 237
• 

  Innobackupex hot backup specifies database table operation

  Project scenario: there are several large tables in an instance, which are history tables that are archived by the development program, but occasionally need to provide queries for the business. Since the instances are backed up in full on a regular basis, it is recommended that these archive tables be migrated to a separate one because the pressure on the instance space and backup is not avoided.

  2022-06-01 11:16:52 Views: 249
• 

  Oracle row-column conversion

  The first is the use of decode, a very common way to write: select sname,sum (decode (course,' language', score,0)) "Chinese", sum (course,' Mathematics', sco)

  2022-06-01 11:16:52 Views: 208
• 

  [reading notes] ORACLE memory management

  Chapter 6 of "Administrator's Guide" introduces memory management for ORACLE instances. In 11g, ORACLE uses automatic memory management (AMM) by default to manage SGA and PGA sizes. In addition to the default method, you can also use the

  2022-06-01 11:16:49 Views: 205
• 

  MySQL8.0 Mgr automatic installation script

  The MySQL8.0 automatic installation script mysql8_install.shmy_test.cnfmysql-8.0.18-linux-glibc2.12-x86_64.tar.xz has three files in the same directory, such as

  2022-06-01 11:16:49 Views: 300
• 

  Front-end knowledge | Flexbox layout mode

  This paper briefly introduces flex, the flexible box elastic layout box model, which is a new type of layout attribute proposed by W3C in 2009. The purpose of introducing the elastic box layout model is to provide a more efficient way to arrange, align and sum the child elements in a container.

  2022-06-01 11:16:41 Views: 254
• 

  WAL logs under pg_xlog cleaned by pg_resetxlog

  There are a large number of logs under PostgreSQL's pg_xlog. There is insufficient space. How to delete them? Darren1:postgres:/usr/local/pgsql/data/pg_xlog: > ls000000010000000

  2022-06-01 11:16:41 Views: 225
• 

  The method to solve the problem that MySql can't connect to the local address localhost

  This article will explain in detail how to solve the problem that MySql cannot connect to the local address localhost. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article. Mysql can't connect to localhost.

  2022-06-01 11:16:40 Views: 232
• 

  Mysql 5.7.17 path Settings

  If we have finished installing mysql, we cannot connect using the cmd command line, as shown in the following figure: the solution is as follows: Step1 path: control Panel-system and Security-Advanced system Settings Setp2 environment variable: Setp3 Select system variable-Path- Edit

  2022-06-01 11:16:27 Views: 261
• 

  Commands for how to view a database

  Editor to share with you how to view the database command, I believe that most people do not know much about it, so share this article for you to learn, I hope you will learn a lot after reading this article, let's go to learn the method! The command to view the database is: [show datab

  2022-06-01 11:16:24 Views: 226
• 

  A preliminary understanding of 3--MariaDB backup and restore of MariaDB

  First, there is no need to say much about the importance of basic knowledge data. What needs to be emphasized is that backup is not the purpose, but recovery is the purpose. Here are some concepts of Mariadb. 1. After the classification of storage engine Mariadb5.1, InnoDB storage that supports transactions is used by default.

  2022-06-01 11:16:13 Views: 211
• 

  Common methods of optimizing Database

  This article mainly introduces the common methods of optimizing the database, the article is very detailed, has a certain reference value, interested friends must read it! The following methods can be used to optimize the database: select the most applicable field properties, minimize the width of the defined field, and set the field N as much as possible.

  2022-06-01 11:16:13 Views: 220