Database Administrator

Bkjia.com exclusive Article] In fact, it is not complicated to delete the data in the database. Why should I do this? First, I will introduce how to delete all the data in the database, because the data may form a constrained relationship between

BKJIA exclusive release] Oracle 11g R2 has been released. This update has many new features. Integration reduces costs and eliminates unused redundancy. Let's take a look at the attractive new features added in Oracle 11g R2. Server cost reduced by 5

The following articles mainly describe the basic function type of the MySQL database stored procedure, that is, the string, which is often used in actual operations, the following articles mainly describe the timing application and related functions

The global shared memory is mainly used for MySQL Instancemysqld processes) and the underlying storage engine to store various global operations and shared temporary storage information, such as Query Cache for Query Cache and Thread Cache for Cache

The following articles mainly introduce the specific content of MySQL limit query optimization. We all know that MySQL database optimization is very important. Limit is the most commonly used and optimized. MySQL limit greatly facilitates paging.

I have been engaged in enterprise system development for many years. In system workflow analysis, I have to analyze SQL statements. When the system accumulates to a certain scale, the database tables involved will grow exponentially, therefore, we

In the previous article, how to build our own data access layer 2, we have implemented the corresponding features of the data access layer. Now we have finished the work. Let's take a look at the code section and try the features of the previous

Many Internet applications provide full-text search functions. Users can use a word or word segment as a query item to locate matching records. In the background, these programs use the LIKE statement in a SELECT query to execute this query.

If you are running a Web application that uses MySQL, it can store passwords or other sensitive information in the application. Protecting this data from access by hackers or prophers is an important concern, because you cannot allow unauthorized

Introduction The Flashback database is a point-in-time (PIT) database restoration method. This Incomplete recovery policy can be used to restore a database that is logically damaged due to human errors. After being introduced in 10 Gbit/s, it is

Before Oracle9i appears, you can only export and import tables to redefine them. Therefore, table redefinition is an offline process. Even an online change to "alter table add NEW_COL NUMBER (3)") will lead to an exclusive locks deadlock. This

We know that the role permissions of users are not available in the stored procedure. For example: SQL> select * from dba_role_privs where grantee = 'suk ';GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE------------------------SUK DBA NO

The first method is to install mysql ODBC and use the export function of SQL server to select the mysql data source for direct data export. This method is simple, but there are many drawbacks for practical applications, the most important

Before Oracle9i, although there was a NEW_TIME function that could change the timestamp of DATE, there was no data type specifically used to store time zone information. In Oracle9i, we can use the DBTIMEZONE pseudo field to query the time zone of

SQL _PLUS, spool ExecCompProc.sql select 'alter procedure '||object_name||' compile;' From all_objects where status = 'INVALID' and object_type = 'PROCEDURE'; spool off @ExecCompProc.Sql;  Organize into a stored procedure

When XML, InfoBase, Webserver, and other concepts are booming, we still see that the current database technology actually only solves 15% of structured data management problems for enterprises, how can we manage the remaining 85% of unstructured

If you have some creative thinking on some special business issues, you will often design solutions in SQL. For example, the company can select one of the following two methods to make the requested fee consistent with the paid fee. The first method

In today's highly competitive market environment, cost control is undoubtedly a very important part for enterprises to improve their competitiveness. As many competitors will provide homogeneous products and services, enterprises must start from

Because the MySQL server has a variety of installation and distribution capabilities and can run on a variety of operating platforms, it also has a variety of Start and Stop methods. You can use one of them according to your actual situation. When

In my opinion, the key to solving the problem lies in identifying the types of the problem and clarifying the solutions to each problem. In addition, many database problems are caused by incorrect operations and incorrect configuration. Therefore,