Database Administrator

I set up an nginx and mysql platform. I just created it and it was inconvenient for mysql not to use phpmyadmin. I took the previous source code and thought it would be okay to modify the database user and password. The phpMyAdmin page displays:

Oracle DBLink script -- Drop existing database linkDrop database link DBLink name; -- Create database linkCreate database link DBLink nameConnect to remote database username identified by passwordUsing '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =

A database trigger is a storage subroutine associated with a data table, view, or event in a database. For example, we can enable the Oracle database to automatically activate a trigger before or after an INSERT, UPDATE, or DELETE expression affects

Linux Oracle 9i The maintenance personnel reported that the database could not be connected. The phenomenon was: tnsping could be connected, but sqlplus could not be connected. If no error was reported, it was always there. The foreground

RunSelect NUM_ROWS, table_name from user_tables where NUM_ROWS> 0, Can achieve the effect.However:Sometimes the data is inaccurate because the table must be analyzed before the query is executed.The analysis table syntax is: analyze table table_name

Environment: Oracle 10g In the first place, we came into contact with the pascal Language. Therefore, sometimes we do not like the C language syntax very much.There is a lazy way of writing in C Language (also exists in java), probably like this:

Oracle10g. A table similar to BIN $ nJ5JuP9cQmqPaArFei384g ==$ 0 will appear after you select and delete it in pl/SQL. 1. view the recycle bin Select * from user_recyclebin; 2. Clear the recycle bin Purge recyclebin; 3. Clear a table in the recycle

-- The output parameters cannot be modified. There are two solutions:-- 1. Change the parameter to the input parameter.-- 2 is to change the parameter to an input/output parameter;Three methods of calling Process1 is to use callWhen you use the call

A major system fault occurred On Weibo a few days ago, and many technical friends are concerned about it. The reason is not as high as James Hamilton's On design and Deploying Internet-Scale Service (1) in summary, James's first experience "Design

The mysqlreport tool is a perl script. To run the script properly, you must install databases such as DBI and DBD-mysql. The current version is 3.5. The following describes the application of the options: -- User USER: user name used to connect to

MySQL's Table xxxx is read only error often occurs on a Linux host. After checking a lot of information on the Internet, I finally found that it is essentially a permission problem. To solve this problem, you must first add the writable permission

This article and its attachments are published in the PostgreSQL Protocol A friend once asked how to clear the cache. Without this function, it is very inconvenient to test. I have made a patch. For more information, see the attachment. Provide

Java calls Oracle functions. A function is essentially a stored procedure that returns a result. This example shows how to call functions with in, out, and in/out parameters. Similar methods. CallableStatement cs;Try {// Call a function without

Before leaving work today, I suddenly received a call from the Bureau asking for a detailed call record for June October. Then, the entire table is started and the extracted records are inserted into the detail table. Now, we can delete tens of

Hash Join Process An example is provided to illustrate SQL _ID gtmmr9gaxqhfr, child number 0-------------------------------------SELECT/* + USE_HASH (d e) */e. ename, d. dname FROM emp e, dept d whereE. deptno = d. deptno Plan hash value: 1123238657

In fact, it is very simple to create an Oracle password file, but to prevent you from forgetting it, record it. Orapwd file =/u01/app/oracle/product/10.2.0/db_1/dbs/orapworacledb password = oracle entries = 10 [Oracle @ oracle10g dbs] $

When a latch free problem occurs, kill the session at that time, report that the session sid does not exist, and kill it at the OS layer, however, the session Status shown in v $ session is still active! This is a silent problem, but it is a test

Explanation of Incomplete recovery In the previous article (loss of the UNDO tablespace caused by RMAN backup and recovery), we talked about how to deal with the loss of the UNDO tablespace. The UNDO tablespace cannot be taken offline. Similarly,

Installing MySQL on Ubuntu is very simple. You only need to open the terminal and run several commands. 1. sudo apt-get install mysql-server 2. apt-get isntall mysql-client 3. sudo apt-get install libmysqlclient-dev During the installation process,

The binary log of Mysql records the information of all mysql database changes, so it is very important to the database. The role of binary log is summarized as follows: 1. It can be used for restoration of databases based on time points. 2. It can