Database Administrator

MySQL auto_increment_increment, auto_increment_offset usage, autoincrement In MySQL, you can specify the auto_increment attribute of the column when creating the table for the ID auto-increment column. It is equivalent to the identity attribute in

Create a materialized view (graphic) Create Materialized View Details I. What is a materialized view? Materialized View is a database object that contains query results. It is a local copy of remote data or used to generate a summary table based on

MySQL Error Log and mysqllog Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These logs help us to

The installation interface cannot be started after Oracle10g is installed in LINUX6. **************************************** ******************************** *************************************** Original Works are from the blog of "Deep Blue

What Does oracle do when data files are offline ?, Offlineoracle SQL> oradebug setmypidStatement processed.SQL> oradebug unlimitStatement processed.SQL> oradebug event 10046 trace name context forever, level 12;Statement processed.SQL> alter

Explore Character Set Issues in Oracle EXP/IMP processes, oracleimp 1. Problem description: Data migration between databases is a common job. EXP/IMP is a common data migration and conversion tool, because the exported files are platform-independent,

The Oracle judgment value is not a number, and the Oracle judgment value is a number Select * from product_info t where t. contract_detailid is not nulland length (translate (t. contract_detailid ,'-. 0123456789 '| t. contract_detailid ,'-. 01234567

Trigger -- start again, trigger -- start The trigger is actually involved in Data Center reconstruction. Some use the stored procedure of the trigger. Now we have encountered the use of triggers in niuyun. Let's start again to see how to use it. To

Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device), rac10.2.0.5Because the customer's database needs to be patched, similar test environments are installed. Install 10.2.0.1 before upgrading to 10.2.0.5. Because I have many articles about

The user specified as a definer ('root' @ '%') does not exist, specifieddefinerZookeeper is generally because the root user has no access permission to the global host. Therefore, you only need to add an access permission to the root user. Solution:

Table schema designer (EZDML) version 1.98 released, ezdml1.98The Zookeeper table structure designer (EZDML) is a free small software for table creation in databases. It allows you to quickly design database table structures and build data models,

Upgrade _ Oracle graphical upgrade with a wider vision (upgrade after dbca database creation)-upgrade 10.2.0.1.0 to 10.2.0.5.0 and dbca10.2.0.5.0 **************************************** ******************************** ******************************

Mysql is completely deleted under win7, and mysql is deleted in win7.First, stop the MySQL service in the Service (Start> Control Panel> Management Tools> service. Open Control Panel-add and delete programs, find MySQL, and uninstall. You can also

Is the DML statement an error because the control file cannot be expanded or is there another reason ?, Dml also has Today, I have handled a very interesting fault problem. The reason is as follows:   The customer's incoming call consultation

PL/SQL Developer tips, pldeveloper 1. PL/SQLDeveloper remembers Login Password      When PL/SQL is usedFor the convenience of work, PL/SQLDeveloper remembers the username and password used to log on to Oracle;   Setting Method: PL/SQLDeveloper 7.1.2 

Create a temporary table in oracle and create a temporary table in oracleThe transaction is automatically cleared after the transaction is committed, and data is isolated between different transactions.Create global temporary table

Oracle determines whether the character is a letter or an oracle characterCreate or replace function ischar (chr varchar2) return varchar2 isIschr varchar2 (5 );BeginSelect caseWhen ascii (chr) between 65 and 122 THEN'True'Else'False'EndInto

MySQL Stored Procedure1. Objectives Learn how to create a stored procedure 2. Syntax CREATE PROCEDURESp_name ([proc_parameter]) [Characteristics...] routine_body 3. Description Create procedure is the keyword used to CREATE a stored PROCEDURE;

How to Use cetos-5.5 to build a forum, cetos-5.5 to build a forum Lab environment centos-5.5 Lab Software Package Yum install-y zlibc gd * pcre * freetype * libpcap * libxml2 * libpng * perl-DBI * gcc * Gcc-c ++ * libtool * fontconfig *

Mysql-based SSL replication/master/semi-sync, mysqlssl This experiment aims to achieve MySQL Data Replication and SSL-based replication on two hosts. * Note the following two problems: 1. Version problem: It is recommended that the versions of the