Database Administrator

MySQL Character Set 1. display character setsMysqladmin-uroot-proot variables | grep character | Character_set_client | latin1 || Character_set_connection | latin1 || Character_set_database | latin1 || Character_set_results | latin1 || Character_set_

1. GOTO, mainly used for jump, but will disrupt our program logic. It is generally not used. It can implement the RETURN and EXIT functions. 2. RETURN: RETURN to the end of the program and end the program. 3. EXIT, mainly used to EXIT the current

Generally, commands are executed as Oracle. 1. Verify that the system dependency package required by Oracle is complete. Rpm-qa binutils compat-db control-center gcc-c ++ glibc-common libstdc ++-devel make libaio libXp 2. Verify System

ROW_NUMBER ()[Syntax] ROW_NUMBER () OVER (partition by COL1 order by COL2)[Function] indicates to group by COL1 and sort by COL2 within the Group. This value indicates the sequential number after sorting within each group (the continuous and unique

When using MySQL C APIs in Linux, You need to introduce relevant libraries and include the header file mysql. h. MySQL provides a mysql_config script that can be used to obtain the parameters during compilation. For example, execute mysql_config --

MySQL provides rich operation interfaces for other programming languages. Generally, MySQL can be well managed as long as SQL statements are supported. Shell has limited support for MySQL, and two common direct operations are used. 1) execute the

In the MySQL environment, the system for user authentication and authorization management is flexible and powerful. It not only manages what operations can be performed, but also controls the hosts from which users can connect to the server. This

I recently conducted a small test to import Oracle Data in the project to mysql and migrate data using mysql migration tool. After the migration, I found some data loss, check the Migration Report and find that max_allowed_packet has exceeded the

The 10046 event of Oracle can track the SQL statements executed by the application and obtain the number of resolutions, executions, CPU usage time, and other information. This is very useful for us to analyze and locate database performance issues.

To control permissions in a project, you must use the Organization class to control the data that can be accessed,For example, A person in organization A can view the personnel data of its subordinate organization, or has the right to view the

// Add the values of a column in the current row to the values of the column in the previous row, that is, the sum of the total values:With t (Select 1 val from dual union allSelect 3 from dual union allSelect 5 from dual union allSelect 7 from dual

// Data Ta Col_1 col_2 ----------- A B C D // Result: Col_1 col_2 ----------- A z0001 B z0002 C z0003 D z0004 // Create table ta ( Col_1 varchar2 (2 ), Col_2 varchar2 (7 )) / Insert into ta Select'A',''From dual union all

The where comparison conditions are as follows: Equal to: =, , >=, <> >, >=. =: Equal ! =, <>, ^ =: Not equal Including: in, not in exists, not exists Range: between... and, not between... and Matching Test: like, not like Null test: is null, is

1. you can use $ ORACLE_HOME/bin/netca to configure the listener on the Oracle server. If the listener Configuration does not use the default listener name (listener), but changes it to another name, the startup method is [Oracle@www.bkjia.com

Oracle physical structure faults refer to various database faults caused by damage to each physical file of the database. These faults may be caused by hardware faults or human error. Therefore, we must first determine the cause of the problem. If

First, make sure that you have successfully installed HIVE and MYSQL Add the following to the hive-site.xml to specify the METASTORE address and Connection Method javax. jdo. option. ConnectionURL jdbc: mysql: // 10.20.151.10: 3306/hive?

The GROUPING function can accept a column and returns 0 or 1. If the column value is empty, GROUPING () returns 1; if the column value is not empty, returns 0. GROUPING can only be used in queries using ROLLUP or CUBE. GROUPING () is useful when a

DECLAREUserid WEB_SITE.USERID % TYPE;Id WEB_SITE.ID % TYPE;CURSOR site IS select id, userid from web_site;BeginOPEN site;LOOPFetch site into id, userid;Exit when site % NOTFOUND; Insert into web_model (id, userId, siteId, name, type,

When installing RAC, the system will prompt you to enter the dedicated node (host), public node (public), virtual node (vip)-These nodes are all set in the system etc file. the public node is used for external or internal personnel to view data.

Ubuntu Edit file/etc/crontab Sudo vi/etc/crontab The cron service not only reads all files in/var/spool/cron every minute, but also reads/etc/crontab once. Therefore, we can use the cron service to configure this file. Crontab configuration is