Database Administrator

MySQL transactions and lock mechanisms The characteristic ACID of a transaction, that is, atomicity, consistency, isolation, and durability. Atomicity ensures that a transaction is a minimum unit, which is inseparable from each other; Consistency

The group_concat function is used in report development. When using report tools such as Jasper or BIRT, some unconventional statistics are often encountered, and the report tools or SQL statements are difficult to process, such as in MSSQL/Oracle,

Deployment and use of the NoSql database Redis in ubuntu, nosqlredis I. Redis introduction: NoSql and No Only SQL are highly concurrent and ultra-large data exist, different from relational databases. Yes: Non-relational, distributed, open-source,

PostgreSQL stored procedure returns a dataset instance, and postgresql Stored Procedure Here we use an instance to demonstrate how to return data sets in the PostgreSQL stored procedure. 1. Prepare the data table first. //member_categorycreate

Record an Oracle 10g data recovery event, oracle10 g Facts have proved that I will not die if I don't die. This Oracle crash took me two days, just because I installed some inexplicable Android simulators and uninstalled them again. After

The future star of NoSQL databases and the future star of nosql DatabasesRelational Database Value When learning NoSQL, we certainly think of the mainstream database-SQL database at this stage. Why does SQL database become the mainstream? It is

Add new data files to the database in the environment of the aix bare device. In a bare device environment, adding data files is a little more troublesome than other environments, because only one data file can be created under a bare device. The

The primary key id is returned when MySql is updated, and the primary key id is returned by mysql. Recently, when I was working on a project, I encountered a logic that the id of the record needs to be returned when I modify a single record. Let's

Oracle object-oriented and set, oracle object-oriented This is a summary of my recent learning experience. 1. oracle object-oriented We all know that SQL is set-oriented, but it is undeniable that there are many places in oracle that reflect the

Java environment variable configuration and java environment variable configuration 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

An example describes Oracle All subqueries, and oracleall subqueries. Problem:The employee names, jobs, and salaries that are higher than the salaries of all salespeople are queried. Analysis:ANY can represent ANY, but this problem requires higher

An example describes Oracle Any subquery and oracleany subquery. Problem:Query the names, jobs, and salaries of employees with lower salaries than any salesperson ("SALESMAN") in the Emp table.Analysis:The salesperson has many records in the Emp

Coalesce and coalesce There is such a demand. There are several contacts in the community. If there is a power outage, first notify contact 1. If not, then notify contact 2; otherwise, notify contact 3. Create table test (Id number,Name varchar2 (20

Number of record set elements and number of elementsAuthor:Www.gudianxiaoshuo.comThis article is organized by the Code Assistant Software and released content is irrelevant to this software.More comfortable reading, more comfortable writing, and

Oracle creation-stored procedures and functions, and oracle creation of Stored Procedures -- Create a stored procedure Create or replace procedure xxxxxxxxxxx_p (-- Parameter IN indicates the input parameter, -- OUT indicates the output parameter,

Add photos to the database and add photos to the databaseAuthor:Www.gudianxiaoshuo.comThis article is organized by the Code Assistant Software and released content is irrelevant to this software.More comfortable reading, more comfortable writing,

Ora-00054: resource busy and acquire with nowait specified solution, ora-00054nowait When a database user inserts, updates, or deletes data from a table in a database, or adds a table's primary key, or the table's index, a ora-00054 often occurs:

Rowid and Oraclerowid in Oracle Each table in Oracle has a rowid, which is an 18-character string, for example, AAANgBAABAAAO/KAAA. it contains a string consisting of A-Z, a-z, 0-9, +. yes. Where the A-Z corresponds to 0-25, a-z corresponds to 26-51,

Oracle Gateway11g R2 access to heterogeneous databases (MSSQL) configuration document-graphic details, gateway11gmssql Directory1. Prerequisites 2. Download transparent gateway 3. Unzip and install transparent gateway 4. Configure tnsnames 5.

A few tips on SQL and SQL Preface: after a previous project was completed, the database and system architecture was designed, the system was put online on schedule after a period of coding with the brothers, and everything was running well at the