commit rollback

Document directory Differences between MySQL versions Differences between MySQL versions   MySQL is an open-source relational database management system. The developers are MySQL AB in Sweden, which was acquired by Sun and finally merged into

Summary of SQL Basics1. The database and database management systems are differentiated by: Databases (DB), Databases Management system (DBMS).2.Type of DBMS: 1. Hierarchical databases (hierarchical database, HDB)2. Relational database

Oracle autonomous transactions are stored procedures and functions that can handle internal transactions themselves and are not affected by external transactions and are declared with pragma autonomous_transaction. To create an autonomous

Characteristics of Oracle TransactionsACID, an abbreviation for the four basic elements that a database transaction performs correctly. Contains: atomicity (atomicity), consistency (consistency), isolation (isolation), persistence (durability). A

The common MySQL table engine has InnoDB and MyISAM, the main difference is that InnoDB is suitable for frequent write database operations, MyISAM suitable for reading the database a little bit more, how to change the table engine InnoDB to MyISAM?

Our company's projects use Spring+mybatis combination. So we have to use the mybatis-spring. So here's a summary of the DAO-level writing problem that mybatis-spring from 1.1 to 1.2 yesterday.Let's take a look at the code for Sqlsessiondaosupport in

In the last article to introduce the MySQL database performance optimization One, today continue to go on the article to introduce the database performance optimization related knowledge. The details are as follows: Establish an appropriate index

Cause: In one of our lines of business, using the older version of the CodeIgniter framework, which has a design flaw in the DB class, is probably not a flaw. But he has affected our production environment, resulting in a chain reaction. has a

With the introduction to spring from this series of articles, we have a preliminary understanding of the use of spring and the two core features of the IOC, AOP, and the combination of my personal work, since the project is a finance department ,

Transaction is one of the core concepts in database system. An application can control the execution and stop of a transaction by starting, committing, rolling back, and so on. From the application point of view, a transaction often corresponds to a

Features that 3.9 MySQL does not supportThis section describes features in other databases that are not available in MySQL. It describes what has been omitted and what to do when these features are needed. In general, MySQL ignores certain features

MyISAM: This is the default type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. Compared to other

When it comes to distributed transactions, online articles are voluminous, theories are many, and practice is many. Some clearly explain the problem, some more confused.I've also written a distributed transaction article, "distributed Message

1. Create a databaseCREATE DATABASE database_name, example: CREATE DATABASE aa;show CREATE database AA; (View database AA)2. Deleting a databaseDROP DATABASE database_name;3.mysql Supported storage engines:Show Engines\g (Note that Defaut is the

I. Distributed architecture detailed 1, Distributed development History 1.1 single point centralized Features: The APP, DB, and Fileserver are all deployed on a single machine. and the number of access requests is low 1.2 Application services and

Turn from: Nested transactions in SQL Server use--transaction count indicates a mismatch between the number of BEGIN and COMMIT statements--The underlying problemProblem:1. System.Data.SqlClient.SqlException (0x80131904): The transaction count after

1. Transaction: A logical unit consisting of a set of commands that ensures that all operations either succeed or all fail.End of transaction: 1) Explicit commit (Commit) 2) explicit rollback (rollback) 3) DDL statement Stealth commit 4) normal End

The main content includes: Create DATABASE, delete database, different types of data storage engine and storage engine selection. Create a database, create a few required databases in the default data directory, with show DATABASES, and see

Another application is in Server management, the parent process that does not involve the database server program to stop running, you can also use these tools to terminate. Why can't the parent process of the database server kill with these tools?

The main contents of this article are as follows:1. Trigger type1.1 DML triggers1.2 Alternative triggers1.3 System triggers2. Trigger composition3. Create a Trigger3.1 Trigger Trigger Order3.2 Creating a DML Trigger3.3 Creating an alternative