Database Administrator

MySQL batch processing SQL statement MySQL supports batch processing to execute a batch of SQL statements. The following example shows how MySQL executes SQL statements in windows batch processing. Create table test (id int, name varchar (20

Simple MySQL database access using C language Unlike Oracle, MYSQL databases do not support embedded SQL languages. However, it provides powerful C and C ++ support APIs. The C language API is in part 1 of the Reference Manual, and is independent of

View MongoDB replica set again Because MongoDB uses memory ing files, the 64-bit version is required. Official: http://www.mongodb.org/downloads Mongodb version used in the lab environment is mongodb-linux-x86_64-2.6.0 Built on three virtual

Oracle cannot find the listener Oracle Server File app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = D: \ app \ Administrator \ product \

INSTR and SUBSTR functions in Oracle 1. INSTR Functions Syntax:Instr (string1, string2 [, start_position [, nth_appearance])Parameters:String1: Source string to be searched in this string.String2: string to be searched in string1.Start_position:

How to query the values of Oracle hidden Parameters What are hidden parameters? Is used in the system, but Oracle does not officially announce the parameters, these parameters may be those that are not yet mature or used in system development. Log

MySQL database builds a series of multiple instances The so-called multi-instance is to build and run multiple MySQL instances on a server. Each instance uses different service ports and listens through different sockets. Physically, each instance

Oracle Cluster physical configuration requirements and restrictions 1. Oracle Clusterware supports up to 100 nodes in a cluster on deployments running Oracle Database 10 grelease 2 (10.2) and later releases. In Versions later than 10.2, oracle

MySQL implements Minus and Intersect) MySQL does not implement the Minus and Intersect functions, just as it does not implement the cube function. You can use SQL to implement the same function, which is troublesome. Drop table t1; Drop table

RMAN full backup script Objectives:1. the backup script is automatically executed at midnight every week.2. Full database backup, control files and archive log files are backed up at the same time.3. the backup is retained for 14 days and

Oracle query field details The SQL statement used to query the detailed information of a field in Oracle contains the table name, field name, type, length, whether it is null, column number, and field remarks. SELECT USER_TAB_COLS.TABLE_NAME as

11g rac rebuilding the SPFILE of the ASM instance 1. PrerequisitesYou need to know the following information:1) number of nodes2) the location of the disk included in the ASM disk group3) There are several disk groups for the instance. 2. Steps and

Oracle 11.2.0.3.0 psu 11.2.0.3.9 in aix Upgrade Oracle psu to 11.2.0.3.9 on aix,Encountered: Copy failed from '/install/17540582/16902043/files/lib/libnnz11.so' to '/oraapp/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so' Please verify all

The Thinkphp framework supports MySQL read/write splitting. In the past, I tried to use Mysql Proxy and Ameba to solve the read/write splitting of MySQL, but the results are not very satisfactory. Now many websites and projects have been migrated

DB2 SQL20321N solution instance SQL20321N was reported during a recent DB2 database migration. Scenario: a clean environment, just installed with DB2, is expected to migrate an old DB2 database to this point. Perform cold backup at the source

Thoughts on SQL/NoSQL database search/query, sqlnosql Reprinted with the source: jiq •'s technical Blog Hbase features: Recently, we have been studying Hbase. Hbase has created an index based on Xingjian, and the query speed is very fast and

ORA-00922: Option Missing or invalid, ora-00922 missing 1. Error description ORA-00922: Option Missing or invalid 2. Error cause 3. Solution Oracle is 11GR2 64-bit, system: win7 64-bit, always prompt "ORA-00922: Option Missing or invalid"

PHP redis operations summary, phpredis class MyRedis {private $ redis; /*** @ param string $ host * @ param int $ post */public function _ construct ($ host = '10. 102.1.8 ', $ port = 6379) {$ this-> redis = new Redis (); $ this-> redis-> connect (

Enq: SQ, enqsq -- Execution per minuteSQL> select SQL _id, mi, count (mi)2 from (select event, SQL _id, to_char (sample_time, 'yyyymmdd hh24mi ') mi --,3 -- session_id4 from dba_hist_active_sess_history5 where SQL _id = '7wxfw53bsmgpq'6 and

Common Oracle modification statements and oracle modification statementsI. Table Test Table: MY_TEST_TABLE -- Create tablecreate table MY_TEST_TABLE( A VARCHAR2(30), B NUMBER(10) default 1, C DATE)tablespace BOSSWG_CFG pctfree 10 initrans 1