MySQL Tutorial - Part - 4 | Transaction control language (TCL) | Savepoint, Rollback and Commit

TCL - TRANSCATION CONTROL LANGUAGE

INSERT , UPDATE , DELETE - Transactions in mysql

# START TRANSACTION (initializes a temp save mode)

COMMIT - def - save changes . # COMMIT ;

ROLLBACK - undo changes and jump back to the required state of the table
# ROLLBACK TO 'savepoint_name';

SAVEPOINT - (checkpoint) temp saved table .
# SAVEPOINT 'savepoint_name' ;

MySQL Tutorial in Tamil (1) - Types of Data - Part 1

MySQL Tutorial - PART 2 - Data Definition Language (DDL) - Types of SQL Statements - MySQL

MySQL Tutorial Part - 3 | Data Manipulation Language (DML) | How to Insert, update and Delete values

MySQL Tutorial Part - 5 | Data Control Language (DCL) | Grant, Revoke and Create User |

MySQL Tutorial - Part-6 | Not null, Unique, Primary key, Check, Default & Auto_increment

[hemar]

Best channel where I'm searching for sql .. where I got this best channel with the great explanation ...kudos for ur efforts...