PHP

View query results in XML format by calling the MySQL command line client program using the traditional-xml option, you can view the query results in XML format (rather than the traditional list form. MySQL query results if you plan to integrate the

After the establishment of Oracle11.2.0.4RAC is complete and the time zone is changed at the system level, it is found that the RAC log records are inconsistent with the operating system time. After Oracle 11.2.0.4 RAC is set up and the time zone is

Database Planning should be oriented to business characteristics and needs, rather than RAC for the availability of RAC. In fact, RAC is not omnipotent, and the following knowledge points need to be mastered. Database Planning should be oriented to

In the Oracle10g era, we envy DBAs who know Oracle9i and have spent Oracle11g and welcomed 12c. However, many DBAs are used to Orac. In the Oracle 10g era, we envy DBAs who know Oracle9i and have spent Oracle11g and welcomed the 12c era. However,

So far, you have learned how to retrieve one or more records from a table based on specific conditions. However, if you want to perform data statistics on the records in a table. For example, if you want to count the results of a polls stored in the

The query function of the SELECT statement (I) is used to query the connection between a statement and multiple tables. The SELECT statement can not only retrieve data from a single table, you can also connect multiple tables to retrieve data. This

According to a recent user survey by Oracle, open-source software is occupying the installation share of Oracle Database software, and about 60% of IT facilities are using some form of open-source software. The survey conducted by the Independent

Running Environment: OS: redhatas4master: MySQL4.0.23slave: MySQL5.0.37slave ERROR message: 06080711: 40: 17 [ERROR] failed. xxx. xxx: 3306, userrepgotthefollowingerror: Access Running Environment: OS: redhat as4 master: MySQL 4.0.23 slave: MySQL 5.0

A few months ago, the famous open-source database MySQL was won by Sun at a price of 1 billion US dollars, which caused hot comments from people in the open-source industry, this purchase will affect this open-source database and the open-source

[From Chen Min's blog] MySQL is increasingly used in database applications due to its small size and efficient operations. When I was developing a P2P application, I used MySQL to store P2P nodes. Because P2P applications have tens of thousands

For database administrators, monitoring databases plays an important role. Compared with commercial database products such as Oracle and SQLServer, open-source databases have consistently performed poorly in this respect, however, after MySQL

Who can connect from there? You can allow a user to connect from a specific host or a series of hosts. There is an extreme, if you want to connect only from one host, you can limit the permission to a single host: GRANTALLONsamp_db. * TOboris @

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: blog. csdn.

When the database undo tablespace file is corrupted or the undo tablespace file is missing, the database cannot be opened. Both cases can be considered as one case, and the solution is the same. Scenario: Create an undo tablespace undotbs02 at and

ZBDBA @ orcl11gselect * fromzbdba; select * fromzbdba * ERRORatline1: ORA-01578: ORACLEdatablockcorrupted (file #3, block #1449) ORA-01110: datafile3: optoracleoradataorcl11gundotbs01. dbf the transaction is being executed, but the database directly

When we restore the archive, we find that the archive is missing in the middle. Most DBAs believe that the archive after the missing archive cannot be recovered. However, in an unconventional way, you can skip the missing archive by modifying the

The database has a three-tier mode and two-tier image. This layer is designed as needed and has certain functions for each layer. This design concept of "performing their jobs" is not only used in databases, but also a typical ISO 7-layer model with

The database system is a data management system. First, we design the data. When talking about the data, we need to look at the development of the database system from the data management history. After reaching the database stage, we will begin to

The general idea is to obtain all the stored procedures from sys. Objects, and then combine dynamic strings to use sp_recompile to re-compile all the SP. SELECTROW_NUMBER () OVER (ORDERBYname) ASRID, execsp_recompile + name + ASTextINTO #

Create a test table: ZBDBA @ orcl11gselect * fromzbdba; NAME alias @ orcl11gZBDBA @ orcl11gZBDBA @ orcl11gZBDBA @ orcl11gZBDBA @ alias, alias (rowid) robject, Create a test table: ZBDBA @ orcl11gselect * from zbdba; NAME alias @ orcl11gZBDBA @ orcl11