Enterprise-level reports usually involve complex permissions, such as text-level permissions and row-level permissions. A regional manager can only view the sales data of the region. QlikView also provides this function. Method: Create a new tab in
1 first, create a sortedset. The command is as follows: The zaddmyset1000 clerk is a command to add a collection element. Zadd indicates adding myset indicates that the Set Name 1000 indicates the key, and the clerk indicates the key. Returns the
The actual project encountered the following problem: the database table stores the number of train tickets for each type of train station, but some railway stations may not sell dynamic or high-speed rail tickets, the final result is 2, and a train
Oracle synonym + dblink actual application business requirements: original database (10.2.0.4.0), new database (11.2.0.3) due to program requirements, now you need
Oracle synonym + dblink actual application business requirements: original database (1
GROUP_CONCAT (expr) This function combines non-null column values according to grouping conditions and returns the result. If a null value exists, null is returned. The complete syntax is as follows: GROUP_CONCAT ([
GROUP_CONCAT (expr) This function
1. How to log on to the mysql database mysql-uusername-p2, how to turn off the mysql service servicemysqlstartstop3, view the mysql status servicem
1. How to log on to mysql database mysql-u username-p 2. How to enable/disable mysql service mysql
When innobakupex is used for backup, it will call xtrabackup to back up all InnoDB tables, copy all files related to table structure definition (. frm), and MyISAM, MERGE,
When innobakupex is used for backup, it will call xtrabackup to back up all
When writing plsql, we often use a classic mode to define a cursor and process the values cyclically from the cursor.
When writing pl/SQL statements, a typical mode is often used to define a cursor and process the values cyclically from the cursor.
The unit tests the Oracle database in a set. I wanted to use DBCA to check the database configuration information. Of course, I was also very confused. Who would think of the following picture. Create new data, number of configurations
The unit
Today's business needs to query Oracle data across databases, so we thought of dblink. Let's take a closer look at OracleDBLink.
Today's business needs to query Oracle data across databases, so we thought of dblink. Let's take a closer look at
Each storage engine is responsible for related shutdown operations. For example, MyISAM will refresh all the operations waiting for write; InnoDB will refresh the bufferpool to the disk (from MySQL5.0.5
Each storage engine is responsible for related
Mongodb operation commands (note that all commands starting with "db." Must be used to access the specified database before the operation)
Mongodb operation commands (note that all commands starting with "db." Must be used to access the specified
1. There are two main functions of Foreign keys: one is to allow the database to ensure data integrity and consistency through foreign keys; the other is to increase the readability of the ERTU; 2. Foreign key Configuration
1. There are two main
About deadlocks in databases. If I encounter a problem in the application, I will not hesitate to transfer it to the DBA. However, from the perspective of the deadlock problem I have received, it is basically the same as the official Oracle
MySQL provides many performance optimization features. One of them is Multi-RangeRead Multi-range read (MRR), which is used for secondary index-based queries.
MySQL 5.6 provides many performance optimization features, one of which is Multi-Range
1. char and varcharchar: Fixed Length, suitable for storing very short (such as house number 101,201), fixed length (such as using uuid as the primary key), column fields with very frequent changes; char (M) each of the Data columns occupies M bytes.
Simple eight sentences teach you how to completely deal with MySQL database I. Connect to MYSQL format: mysql-h host address-u user name-p User Password 1. Example 1: connect to MySQL on the local machine: first, open the DOS window, enter the
Using crontab, the system regularly backs up the mysql database [Content Abstract] using the system crontab to regularly execute Backup files and save the backup results by date to achieve the purpose of backup. The system crontab is used to
1. Check and process lost documents ORCLLDG_PRIselectmax (sequence #) fromv $ archived_log; MAX (SEQUENCE #) -------------- 9ORCL_STDselectsequence #, SEQUENCE; sequence # If the APPLIED------------------6YES7YES8YES9CURRENT queries
1. check and
Redolog has a redo thread relative to each database instance. In a typical configuration, only one database instance accesses the database, so only one redo thread appears. But in RAC
The redo log has a redo thread relative to each database instance.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service