Database Administrator

Use the graphical tool MySQL WorkBench to remotely manage MySQL in Linux If you run a MySQL server on a remote VPS, how do you manage your remote database host? Web-based database management tools such as phpMyAdmin or Adminer may be the first thing

ORA-00904 scn_to_timestamp In Oracle, the scn and time can be converted to each other, and the friend's database is 10.2.0.5. Previously, it was normal to convert the scn to the corresponding time through scn_to_timestamp, but an error was reported

Use Redis for pre-stock Cache Recently, in my work, I gradually switched the cache of one of the PHP projects from the previous APC cache to Redis, and implemented inventory maintenance based on the data structure supported by Redis. The cache is

Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4 I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC

The difference among Cursor, hidden Cursor, and dynamic Ref Cursor is displayed in PLSQL. plsqlref1. Explicit cursorExplicit is relative to implicit cursor, that is, there is a clear declared cursor. The declaration of an explicit cursor is similar

Oracle Database Operations (10)-logical backup and recovery of databases (tables), oracle backup and recovery Logical backup and recovery of databases (tables)-export System can export any scheme, for example: Exp system/manager @ myoral owner

Oracle non-critical file recovery, redo, temporary files, index files, password files, and oracleredo The Application of Incremental backup is in the rediscovery stage and is no longer in the restore stage. Learn about the database settings

IT Ninja Turtles PL/SQL Developer tips and shortcuts, Ninja Turtles developer 1. SQL plus Window: File-> New-> Command Window. This is similar to the SQL plus client tool of oracle, but it is much easier to use than it. 2. Set the Keyword to

Software Engineering-software testing, Software Engineering Software Testing After the system is complete, it is time to test the system. This must have been the first system of acceptance. We are confident that the system will be accepted by the

Use Ubuntu Server to Set Up Windows file sharing based on independent hard disk and FTP Server (configuration work), ubuntu file sharing This chapter covers the environment configuration and New Hard Disk addition and settings of Ubuntu Server. 1)

Key-Value Pair storage (1): What is key-Value Pair Storage? Why? Author: Emmanuel Goossaert Original article: codecapsule.com In this article, I will begin with a short description of what a key-value pair is. Then I will explain some reasons for

In-depth understanding of how to configure MongoDB in MongoDB (1) LinuxI MongoDB Introduction   MongoDB is a high-performance, open-source, and non-pattern document-based database. It is a popular NoSql database. It can be used in many scenarios to

Use emca to install and configure Oracle Database Control on the command line interface. As a loyal user of the command line, the O & M of the server software tends to be completed using commands or scripts, so it is annoying to use a large amount

SQL Injection principle and solution code example, SQL example 1. What is SQL injection? 1. What is SQL injection? SQL injection is to insert SQL commands into Web forms to submit or input query strings for domain names or page requests, and finally

Linux mongodb installation and data import and export tutorial, mongodb Import and Export How to install mongodb and import and export data in Linux # Viewing the linux release version Cat/etc/issue # View the Linux kernel version Uname-r 1. General

1 Introduction to null valuesNULL is a unique data type in the database. If a column in a record is NULL, the value of this column is unknown and uncertain. Since it is unknown, there are several possibilities. Therefore, NULL is not a definite

Microsoft's new CEO Nadella said that Microsoft will become "mobile first, cloud first", which means that Microsoft's various cloud services will be improved and strengthened. According to the latest news, after using the new brand OneDrive,

Two problems encountered during impdp import: impdp import encountered two problems Two days ago, you need to import the data dump exported from a remote test database using expdp to a local test environment. Some problems are encountered, which is

High Performance MySQL Reading Notes-query performance optimization, high performance mysql For high-performance database operations, it is not enough to design the optimal database table structure and build the best index. You also need to design

MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"