Database Administrator

1. OverviewThere are two ways to import a MySQL database:1) Export the database SQL script first and then import it;2) directly copy database directories and files.In different operating systems or MySQL versions, the method of directly copying

MySQL stored procedures have been criticized for lack of debugging tools since the birth of MySQL 5.0. Since its acquisition by SUN and ORACLE, MySQL products have experienced many improvements in both functionality and performance. However, in

Insert declare v_empno emp. empno % TYPE: = & empno; v_ename emp. ename % TYPE: = '& ename'; v_salary emp. sal % TYPE: = & sal; begin insert into emp (empno, ename, sal) VALUES (v_empno, v_ename, v_salary); COMMIT; END; update declare v_empno emp.

1. What is a NoSQL database? What is the difference between NoSQL and RDBMS? Under what circumstances do I use and do not use NoSQL databases? NoSQL is a non-relational database, NoSQL = Not Only SQL. Relational databases use structured data, while

In the recent elective course system, we need to consider the problem of database data inconsistency caused by concurrent database operations-because it is a school-wide Elective Course, a large number of students choose courses at the same time,

Partitioned indexes are classified into global indexes and local indexes. Local indexes can be divided into prefix indexes and nonprefix indexes. Currently, global indexes only support indexes with a prefix. Both the B-tree index and the bitmap

Connect C ++/C to the MySQL database in Linux (2) -- return data SQL reference: The SQL statement that returns data is used to retrieve data records that meet the conditions from the database. There are four steps to retrieve data from the MySQL

There are many restrictions on using mybatis independently (for example, transactions that span multiple sessions cannot be implemented), and many business systems are originally transactions managed using spring, therefore, it is best to integrate

DATAGUARD configuration is as follows: PROD is the master database, SBDB is the slave Database 1-3 log groups are redolog files and 4-6 log groups are standby logs. After the standby log is created, the master database closes the database and uses

Problem description: Recently, I am working for a school. NET website, called the process-based score Entry System of wenzheng University. The old User Login system needs to import existing data from the old system to the new data table, USE

1. Start the server File In the install subdirectory of the Sybase directory.RUN_server (here the server represents your server name, for example, here I am RUN_FENGLB) Name, edit this file,Add the parameter "\ data \ master. dat-sFENGLB" to save

We know that the most popular MySQL standalone version is INNODB, the only engine that supports full transactions. Its characteristic is that the data itself is organized by B-TREE, the data itself is a huge B-TREE index based on the primary key

The recent project involves a large amount of data. The specific problem is: monitoring digital TV signals, monitoring the transmitted code streams, and monitoring 20000 streams per second, each stream corresponds to more than 20 metrics, which are

The Master/Slave configuration of the mysql server, which can implement read/write splitting, or restore data from the slave database after the master database fails.Two machines are required, mysql is installed, and the two machines must be in the

After Oracle is installed, the first thing to do is to think about how to connect and proceed. SQL Developer is a powerful tool officially provided. In my opinion, it is also the first choice. The latest version on the official website is 4.0.1.14.48

This article is based on Mysql storage program usage Storage Functions The storage function returns the result to the caller. Create an instance using a storage functionMysql> delimiter $ // set $ as the separator mysql> create function

Apply operator in SQL SERVERApply Operator You can use the APPLY operator to call the table value function for each row returned by the External table expression that implements the query operation. The table value function is used as the right

1. del key1 key2 ''''' Add version 1.0.0. Time Complexity: O (n) N indicates the number of keys to be removed. Remove the key of a single string. the time complexity is O (1 ). Remove keys of a single list, set, sorted set, or hash table type. The

Character Set is a set of symbols and encoding rules. Both the oracle database and mysql database have character set selection problems. Character sets are important for databases, because most of the data stored in the database is various texts.

Now that we have this requirement, we need to have some knowledge about deadlocks to solve deadlocks. For non-DBAs, we do not need to know much about them, you just need to know the basic concepts and common analysis methods. After all, we don't