MySQL Beginner Course: Chapter 10 - Transactions

MySQL Beginner's Course is a complete MySQL series that will help you get started with MySQL and you'll be ready for work in no time.

SET operators in MySQL are used to join the results of two or more SELECT statements. In this chapter on SET Operations we will go over the following:
1. UNION
2. INTERSECT
3. MINUS

Thank you for tuning in! If this helps you do consider liking the video and subscribing to the channel, it helps in creating more free content :)Chapter Chapter 9 : MySQL Beginner's Course is a complete MySQL series that will help you get started with MySQL and you'll be ready for work in no time.

In MySQL, a transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. In other words, a transaction will never be complete unless each individual operation within the group is successful. MySQL transaction allows you to execute a set of MySQL operations to ensure that the database never contains the result of partial operations. In a set of operations, if one of them fails, the rollback occurs to restore the database to its original state.

In this chapter on MySQL Transactions, we'll learn
1. Transaction Set
2. Rollback
3. Table Locking

Thank you for tuning in! If this helps you do consider liking the video and subscribing to the channel, it helps in creating more free content :)

#mysql #transactions #mysqlcourse

[adamyogisyahputra]

I dont know why but it doesnt work on the rollback. Already follow the guide, autocommit =0; start transaction; but when i delete it and rollback, it stays deleted. Same in the line client, it also show empty set, weird

[oliverchen]

could you share the sample database used in this course ?

[adityachaudhari]

hey hi. can you tell me where have you got the music which is at the beginning of your video. did you downloa or some made it for you.

[himanshukandwal]

why @ symbol in query? what is @OrderNumber ? why it is not orderNumber? pls tell

[sulemanmasood]

sir my db is in mysql using MYISAM.... No foreign keys implemented with some columns repeating in tables as well... i have approximatelly 40 tables and all containns approx 500 rows.... but two or 3 tables contains above one million rows....db is not it is still working fine...on LAN and on cloud as well ... what will be future of my db... can u help me...