Category：Database
-
Oracle file automatically “weight loss” record
Article Catalog preamble 1. Archive log deletion Overview of archiving scheduled deletion 2. Listening to logs Listening Overview scheduled deletion 3. Alarm log Alarm log description overview scheduled deletion 4. Backup Delete Full Script Backup Delete preamble Daily operation and maintenance we will encounter a variety of Oracle files are too large, resulting in disk […]
-
[MySQL] Database and Table Operations
Database and table operations I. Database operations1. Creation of databases2. Character sets and checking rules(1) View the system’s default character set and checksum rules(2) Check the character set supported by the database(3) Check the character set checking rules supported by the database(4) Impact of checking rules on databases 3. Manipulating the database(1) Viewing the database(2) […]
-
Oracle 12CR2 RAC deployment rollover, bug avoidance experience
Article Catalog 1. Introduction to Oracle 12C Release 2. Calls to the graphical interface 2.1 VNC calls 2.2 MobaXterm Calls 3. root.sh errors 3.1 Solutions for CLSRSC-400 3.2 Failure to execute root.sh step 19 4.DB Apply Patch 4.1 opatch apply reports errors 4.2 DB startup errors 5. Summary I believe that for those of you […]
-
Resolved the Java. SQL. SQLNonTransientConnectionException: Could not create connection to the database server abnormal correctly solved
Resolved Java. SQL. SQLNonTransientConnectionException: Could not create connection to the database server abnormal correct solution, kiss measuring effective!!!!!! Article Catalog report an error problemSolutionscureexchanges report an error problem java.sql.SQLNonTransientConnectionException:Could not create connection to database server Solutions The error “java.sql.SQLNonTransientConnectionException:Could not create connection to database server” is usually caused by an inability to connect to the […]
-
Flutter Application – Upgrading Database with sqflite
Article Catalog Description of the problem concrete approach code example More Conditional Upgrades Introduction to Database Migration and Backup Database migration Database Backup Description of the problem After the release of the application developed using fluttter, I realized that the database is not well designed. How to update the database? Using sqflite to handle the […]
-
MySQL 5.7 Detailed Download, Installation and Configuration Tutorial
The following MySQL 5.7.27 Detailed Download, Installation and Configuration Tutorials [A long time ago also recorded a MySQL8.0 installation and configuration process, if 8.0 can refer to another article below] MySQL Download and Installation and Navicat Configuration (Super Detailed) _Kilimanjaro Dawn’s Blog – Blog_navicat configuration mysql I. Preface Recently had a few years ago, the […]
-
[MySQL] Column Collection, from Basic Concepts to Tuning
catalogs catalogs 1. Basic concepts and SQL 2.SQL Tuning 3. Optimize the index 4. Some engineering issues 1. Basic concepts and SQL Article Link: MySQL Basic Concepts and SQL__BugMan’s Blog – Blogs This section will talk about basic MySQL concepts and SQL operations, and will cover the following topics: What is MySQL Relational, non-relational database […]
-
Mysql installation and configuration tutorial (detailed)
First a brief overview is divided into several steps: I. Download Mysql II. Installing Mysql Third, verify that the Mysql installation is successful IV. Configuring environment variables V. Verify that the configuration of environment variables is successful I. Download Mysql To install MySQL on Windows or Mac, first download the latest version of MySQL Community […]