<div>
<div class="content wysiwyg-content">
HI,<br />
Going by normal terminology if suppose A transfers amount of 10 into account of B.<br />
then i will run two queries <br />
update A &nbsp;set A = A-10<br />
update B set B &nbsp;= B -10<br />
(just writing a pseudocode above for illustration)<br />
<br />
will that be called a transaction ??<br />
<br />
Also i see that <b>transaction</b> is a special keyword in mysql.<br />
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.<br />
Thanks
</div>
</div>


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

whats a transaction in mysql

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.