Rohit Bajaj
asked on
whats a transaction in mysql
HI,
Going by normal terminology if suppose A transfers amount of 10 into account of B.
then i will run two queries
update A set A = A-10
update B set B = B -10
(just writing a pseudocode above for illustration)
will that be called a transaction ??
Also i see that transaction is a special keyword in mysql.
What does transaction refers to the thing that we start with start transaction or any set of statements or queries can also be called a transaction depending on some logic.
Thanks
Going by normal terminology if suppose A transfers amount of 10 into account of B.
then i will run two queries
update A set A = A-10
update B set B = B -10
(just writing a pseudocode above for illustration)
will that be called a transaction ??
Also i see that transaction is a special keyword in mysql.
What does transaction refers to the thing that we start with start transaction or any set of statements or queries can also be called a transaction depending on some logic.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.