Database Administrator

Find this article, which mentions MySQL encoding conversion from latin1 to UTF8. Add to favorites. Recently, all the databases will be transferred once, And latin1 is always incorrect. It will be too much trouble if it is not transferred. SET

To install phpMyAdmin, record the following points: Install phpMyAdminDecompress the package to/var/www.Configure ApacheListen 8030.DocumentRoot/var/www/phpMyAdmin Cp config. sample. inc. php config. inc. phpVi config. inc. phpModify the following

In RedHat 5.5, Oracle 10 Gb cannot be easily installed. When querying data, the Chinese text displayed on the terminal is garbled: SQL> select name from scott. student where id = 23; NAME ---------- ?? Each Chinese Character displays a question

Authoritative Performance Testing Organization (TPC) was confirmed on December 3, the previous day Oracle submitted the names of the T3-4 Supercluster, with a total of 30 249 transactions per minute (transactions processed per minute. The original

What is session?Generally speaking, session is a context between the communication end and the communication end ). This context is a piece of memory on the server side: it records the client machine of the connection, the application through, and

1. Install the rpm package Nano/v. sh Copy the following content For x64 #! /Bin/bash Rpm-Uvh kernel-headers-2.6.18-194.el5.x86_64.rpm Rpm-Uvh glibc-headers-2.5-49.x86_64.rpm Rpm-Uvh glibc-devel-2.5-49.i386.rpm Rpm-Uvh

Test Import and Export todayIt is understood that if imp AND exp are used for import and export, as long as Oracle tools of the same local version are used, there is no problem with importing and exporting different versions of parts. For example,

Before Oracle 11g, the alter file of oracle was under the bdump directory. Oracle 11g provides Alert logs in XML and traditional text formats. The location of the new oracle 11g log is determined by the Automatic Diagnostic Respository (ADR. You

Definition: Stored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database. You can run a stored procedure by specifying its name and providing parameters (if the stored procedure has parameters.

Found onlineNIf you have more information, none of them will succeed successfully. If you are depressed, the level may be limited ...! I have been continuously researching, testing, and fully implementedLinuxStart twoMysql, and have a better

How to count the total number of records deleted after execution of the delete statement in PLSQL. Oracle uses two types of cursor: explicit cursor and implicit cursor. No matter how many records are returned by the statement, PL/SQL implicitly

To group queries by time period, you must first understand the addition and subtraction of level, connect by, and Oracle time.I will write only one query statement about level:  --- Level is a pseudo-Sample  Select Level FromDualConnect By Level

In today's project, you need to create a materialized view for multi-table join and refresh it once every two minutes. Oracle ORA-02063 error Solution As shown in:   The refresh method of my refresh statement is force. This method will first try to

Youmust regularly gather statistics on database objects as thesedatabase objects are modified over time. To determine whether agiven database object needs new database statistics, OracleDatabase provides a table monitoring facility. This limit

ORA-16249 master database down, logical standby direct change master database SQL> alter database activate logical standby database finish apply;Alter database activate logical standby database finish apply*ERROR at line 1:ORA-16249: Terminal apply

As we all know, in the mmm environment, the data in each database is consistent. What you see after amoeba is consistent is that the Server Load balancer has been used, and you cannot see it. So what should we do? Here we can use a parameter in/etc/

1.1 example of tables with OU shielding SELECT t.org _ id, t. * FROM po. po_headers_all t -- unshielded table, running data in PL/SQLSELECT t.org _ id, t. * FROM apps. po_headers t -- contains OU blocking and no data is queried in PL/SQL. 1.2

First look at the example Example 1: select ltrim ('caolingxiong ', 'cao') from dual; ------ The returned result is ---------- Lingxiong This result is expected because the beginning of the first parameter is the same as that of the second

MySQL installation methods include rpm and source code compilation and installation. This article will demonstrate installation without compilation.I. installation and configuration 1. Create a mysql user and decompress the mysql installation

Oracle example:Select extract (year from sysdate) from dual; // return Current YearSelect extract (month from sysdate) from dual; // return Current MonthSelect extract (day from sysdate) from dual; // return Current DaySelect extract (hour from