Database Administrator

Development idea of using Lua script in Redis Redis provides the eval command to execute the Lua script. The following example shows how to execute a Lua script on the Redis server. 1. Run the following commands to execute the Lua script:

Oracle NULL column and PL./SQL Execution Experiment Today, we have some experiments on Oracle NULL values. We will discuss how to insert NULL values. 1. You can insert ''or NULL in PL/SQL, provided that the column is allowed to be empty. 2. You can

Use the snapshot feature of LVM to implement almost hot backup of data The snapshot function of LVM can record information at a certain time point to the snapshot area. Therefore, you can use this feature to completely back up data. Then, the new

Installation of Oracle in Virtual Machine use PLSQL Developer Connection tutorial in host machine, oracleplsql To meet the development requirements, install the XP system and Oracle on the VM, and install the Oracle Client and PLSQL Developer on the

File system and database comparison, file system databaseComparison between file systems and databases This article compares common file systems and database technologies from the perspective of Single-host systems. There should be many

Mysql: Communications link failure solution, failure Mysql: Communications link failure solves the problem of connecting to MySQL using Connector/J. After the program runs for a long time, the following error will be reported: Communications

Redis Admin UI-A Redis UI management interface, redisuiRedis Admin UI-A Redis UI Management Interface  The Redis management UI consists of two parts:   1. an Ajax client Web application (developed based on Google's closed Library: https://github.com/

The object attributes of the MySqli extension Library and the process-oriented comparison with the mysql database. After learning the mysql database to operate mysql, this is a process-oriented method. However, object-oriented is the trend of the

SQL Server Reporting Services create and subscribe to reports, reportingservices If the data in the database is updated in real time, and the report we use for research and evaluation is based on such real-time data, then we can use the SQL Server

MySQL Workbench query timeout time out (Lost Connection) solution, mysqlworkbench When using MySQL Workbench for query, if the query statement or table is too complex and the query time is too long (generally 600 s), the Lost Connection error is

Ubuntu SQL tutorial for new mysql users and ubuntumysql for new users Ubuntu SQL tutorial for mysql beginners   1. Start the mysql database: Effect: 2. Enter mysql: Effect: 3. view all databases: Effect: 4. Create a database:

MongoDB-NoSQL, nosql Comparison between mongoDB and SQL: The biggest difference from a common database is structured and unstructured. NoSQL: Generally, it refers to non-relational databases. Compared with relational databases, in fact, its previous

The path to installing and detaching Oracle databases: The Path to oracle databases ========================================================== ============================================== ====================================== 1. If there are two

Mysql build and basic commands, mysql build commands I. mysql setup process Install mysql on ubuntu 1. sudo apt-get install mysql-server 2. sudo apt-get install mysql-client 3. sudo apt-get install libmysqlclient-dev 2. Basic commands-Logon,

Part 1 basics Chapter 2 install MongoDB and basic mongodb Statement: This article is mainly from the book "MongoDB Practice". I want to learn the knowledge and understanding of MongoDB through this book, so I wrote it in my blog post, as recorded in

Failed to upgrade Oracle Cluster Registry configuration, raccluster during 10g rac Installation Failed to upgrade Oracle Cluster Registry configuration was encountered during 10g rac installation, because the BUG was triggered by using the DMM multi-

Optimistic locks and pessimistic locks, optimistic locks pessimistic locks Locking) This concept has been touched upon when we learned multithreading. In fact, the lock here and the concurrent lock processing in multithreading are a truth. They all

Simple tutorial for SQL statements in linux --- CREATE TABLE, simple tutorial --- create A table is the basic architecture for storing data in a database. In most cases, the database vendor cannot know how to store your data. Therefore, you usually

Summary of database Principles and Applications Review questions, database principles questions   Summary of database Principles and Applications Review questions I. Single-choice questions (1 point for each question, 20 points in total) 1. In the

SQL stored procedures update data through multiple IDs, SQL stored procedures The following is an example: I want to add 1 to the name of some brands (that is, Brand_Name), and Brand_ID is the primary key. The SQL statement is easy to implement. But