Breaking News

MySql Tutorial

MySQL general security issues

Here, in this section you will study about different general security issues in MySQL. Security Guidelines Always keep in mind the following security guidelines before working with MySQL. Do not permit or allow anyone to access the …

Read More »

The MySQL Access Privilege System

Here, in this section you will study about different Access Privilege Systems. Privileges Provided by MySQL Here, MySQL provides privileges that apply in different contexts and at different levels of operation: Administrative privileges allow users …

Read More »

MySQL and the ACID Model

ACID stands for Atomicity, Consistency, Isolation and Durability. It is a set of properties that guarantee that database transactions are processed reliably. In MySQL, InnoDB storage engine supports ACID-compliant features. Atomicity: The atomicity aspect of the …

Read More »

MySQL Transaction

MySQL in version 5.6 supports local transactions means within a given client session through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. Syntax of START TRANSACTION, COMMIT, and ROLLBACK: START TRANSACTION transaction_characteristic [, …

Read More »

LOCK and UNLOCK Tables

MySQL allows client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires …

Read More »

SET TRANSACTION Syntax

SET [GLOBAL | SESSION] TRANSACTION transaction_characteristic [, transaction_characteristic] … transaction_characteristic: ISOLATION LEVEL level | READ WRITE | READ ONLY level: REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE Let us describe you the …

Read More »