The transactions are supported only on the syntax level to allow integration with tools that requires it. While the syntax is accepted, all the queries are executed immediately and with no transactional guarantees.
These commands are used to manage transactions:
Initiates a new transaction.
Saves the changes made in a transaction to the database. It simply ends the transaction.
In Oxla, when you issue a ROLLBACK command, it doesn't undo changes made in the current transaction. It simply finishes the transaction without any rollback action.
1) Let’s define a table named products with columns: product_name, price, and stock_quantity.
2) Next, we want to insert product data into a products table.
The INSERT statement is executed immediately without waiting for the end of the transaction or until a COMMIT is issued.
You will get the following output:
3) View the changes by displaying the products table:
The product data is now added to the table.