Database Administrator

Connection to MySQL database (driver not loaded) with QT5.5 in CentOS7 (64-bit) To connect to MySQL using qt, you need to share the driver of libqsqlmysql. so. The path is under the plugin/sqldrivers directory. At first glance, it is available, but

Encapsulate PL/SQL code in a smart package The vast majority of PL/SQL-based applications are composed of thousands or even millions of lines of code, which contains detailed and variable user requirements.Commercial logic is initially implemented

Oracle 11g statistics collection-collecting multi-column statistics When writing an SQL statement, we may encounter multiple conditions following the where clause, that is, we can filter the data based on the conditions of multiple columns. By

ORA-00600 troubleshooting and analysis examples Yesterday to deal with a ORA-00600 of errors, which also experienced various twists and turns, really look at the flowers in the fog, after seeing through a lot of problems are found to have a reason.

Troubleshooting of default temporary tablespace and redo log files in Oracle Problem: I want to synchronize Oracle Data to MySQL now. the ETL tool is used because the data volume is large and temporary tablespace is used for subqueries, resulting in

SQL Server 2016-locally compiled Functions The native compiled stored procedure is introduced in SQL Server 2014, and in SQL Server 2016, we will be able to implement a Scalar User-Defined Function (Scalar UDF) natively Compilation ). SQL Sever

MongoDB3.0.x user authorization configuration (standalone environment) By default, the MongoDB database does not have permission control. It can be accessed by connecting to the opened port and has root-level permissions; the production environment

Mysqldump: Got error: 1045: Access denied for user 'roor' @ 'localhost' (using pas sword: YES) when tr, 1. Error description C: \ Users \ Administrator> d: D: \> cd MySQL \ Program Files \ MySQL Server 5.6 \ binD: \ MySQL \ Program Files \ MySQL

Error code: 1066 Not unique table/alias: 'C', 1066 unique 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT (select concat (s. name, '/', sr. reame, '[', DATE_FORMAT (. startTime, '% Y-% m-% D'),'] ') FROM

DRP problem series -- The Network Adapter cocould not establish the connection, drpestablish After the last problem is solved, another new problem occurs. There will always be too many disappointments in life. Let's take a look at the problem

PL/SQL Developer functions of various windows, pldeveloper Understanding the functions of each window is the primary condition for the correct use of PL/SQL Developer. The following briefly describes the functions of PL/SQL Developer

Fault case: problems that may be caused by regular backup and fault case backup Scenario 1: The database memory is 1.5 GB, with few businesses. The qps is less than 10 at ordinary times. The memory usage soared to 100% from to every morning. When

Example of mydumper backing up mysql database and mydumpermysql Mydumper is a lightweight third-party open-source tool for mysql database backup. The backup mode is logical backup. It supports multithreading, And the backup speed is much higher than

Convert multiple columns into one row, and convert multiple columns into one row. A friend asked me how to convert multiple columns into one row in Impala. In fact, the built-in functions in Impala can be implemented without using custom

Oracle 11g R2 installation tutorial, oracle11g I, Note that Oracle is divided into two files. After downloading, extract the two files to the same directory. In the path name, it is best not to show Chinese characters or irregular characters such as

SQL Script for select data from ebs and make a csv file to FTP, ebscsv Declare cursor cur_lcy_test is select rcta. customer_trx_id, rcta. trx_number, rcta. trx_date FROM ra_customer_trx_all rcta WHERE rcta. customer_trx_id = 11993; -- rec_lcy_test

Hive index, hive 1. Hive index Overview Hive indexes aim to improve the query speed of specified columns in Hive tables. If no index exists, a query similar to 'where tab1.col1 = 10', Hive loads the entire table or partition and processes all the

Analysis of data leakage investigation report in 2014 and investigation report in 2014Web application attacks are one of the top concerns about Verizon data leakage Investigation Report (DBIR) data disclosure in 2014. These events mainly affect

MySQL is sorted by Chinese characters and Pinyin letters, and mysql is sorted by Chinese Characters If the MySQL encoding format is GBK character set, you can add Order by name asc; -- sort in ascending order If the utf8 character set is used,

Difference between count (*) and count (field name) in SQLThis article uses examples to describe the differences between count (*) and count (field name) in SQL. For details, refer to examples. I did not pay attention to the difference between the