Database Administrator

Six things that MySQL should learn Because of its small size and efficient operations, MySQL is increasingly used in database applications. As an important part of LAMP or WAMP development, MySQL deserves the attention and earnest learning of PHP

Temporary tables and memory tables in MySQL MySQL memory table: 1. Use max_heap_table_size in My. cnf to specify dynamically 2. The table is defined as stored on the disk. The extension is. frm. the restart will not be lost, and the data will be

Guide on installing MongoDB databases in Linux Guide on installing MongoDB databases in Linux 1. Create an installer N/ Note: We generally create a mongodb user. This allows O & M to help create 2. Upload mongodb data software. N/ Annotation: Using

Solution to failure of MySQL startup in Ubuntu I found that the MySQL database on one of our Ubuntu servers is stuck. It may be a deadlock, so I tried to use the Command service mysql restart, result MySQL returns the stop/waiting status when it is

Status values related to MySQL query statement statistics and query Cache The status values Com_select, Queries, Questions, Qcache_hits, Qcache_inserts, and Qcache_not_cached output by 'show global status' in MySQL have been somewhat confused, now

Redhat6.3: redhat6.3oracle10gVersion description: Operating system version: redhat6.3 x64 Oracle version: 10.2.0.1 Experience: Some problems are encountered during version matching today. This is mainly caused by missing packages. Let's summarize it

MySql learning, mysql learning notesSet two database tables for database query The first table user contains: User_id Username Age Sex 1 Alps1992 22 Man The second table toy contains

Batch CRUD data of Mysqli, mysqlicrud After learning to use the mysqli extension library, the overall feeling is more rational than the process-oriented method, object-oriented is the trend of the times, so we must not just use that old mysql

Meaning of => in oracle function parameters, meaning of oracle function parameters Author: iamlaosong Today we see an MD5 encryption problem. Many languages provide encryption functions. oracle also provides MD5 encryption functions. I searched

Mongodb error: 10061 unable to connect because the target computer is actively rejected, mongodb10061 When connecting mongodb, mongod.exestart is used first, and mongo.exe is used to connect to the database. However, the following error occurs

Install Goldengate upload data, goldengateveridata Goldengate internal data is a tool for oracle to compare data consistency. It supports Oracle, Terdata, SQL Server, and other databases. Start installation below: Overall architecture: Installation

SQL column to line, SQL column to line Normal row/column Conversion(AI xinjue Luo. Yu Hua in Sanya, Hainan) Assume that there is a student renewal table (tb) as follows:Name Subject ResultZhang San Language 74James math 83Zhang San physical 93Li Si

Management of user permissions in the background database design, management of user permissions in the background From prism school-online IT education www.prismcollege.com 1. Create a basic table Create three tables: User, Role, and Module. each

[Translated from mos] in RAC database, how does one kill a session independently of an instance ?, Mosrac Source:How to Kill a Session on RAC Database In Instance Independent Fashion. (Document ID 869777.1) Applicable:Oracle Database-Enterprise

Concerning the problem that the number of records returned by the ADO record set GetRecordCount () is-1, adogetrecordcountTo operate databases using ADO, we usually use the GetRecordCount function to quickly determine the total number of records in

[Translated from mos] Which JDBC driver version supports scan ip addresses ?, Mosjdbc Which JDBC driver version supports scan ip? Source:Which JDBC Driver Versions Support SCAN? (Documentation ID 1150835.1) Applicable:JDBC-Version 10.2.0.1 to 11.2

Oracle subquery, create and manage tables, and oracle query CreationSummarySubquery: Single Row subquery: returns a single rowUse Single Row comparison OperatorsMulti-row subquery: multi-row subquery returns multiple rowsMultiline operators:IN, ANY,

The method for resetting the auto-numbered column in SQLite. Currently, all popular databases provide automatic numbers, and SQLite is no exception. When the database contains an automatically numbered field, SQLite automatically creates a table

11g RAC full installation diagram (VM Workstation8.0 + Centos5.5) 02-Oracle Installation, vmworkstation Run the following command on node 1 (crydb01: [root@crydb01 app]# chown -R oracle:oinstall /u01/app/oracle[oracle@crydb01 database]$

12.1 upgrade roadmap and 12.1 upgrade Roadmap Minimum version of the database that can be directly upgraded to Oracle 12c Release 1 (12.1) --- direct upgrade   Source Database Target Database 10.2.0.5 12.1.x 11.1.0.7