![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/begin1.png\")
<\/p>\n
When we run the query above, we see that our table has been created by looking at the query result.<\/p>\n
![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/begin2.png\")
<\/p>\n
Our table has been created, but when we go to the Tables tab and check, we cannot see that our table has been created.<\/p>\n
The reason for this is that we opened the transaction with the begin command but did not close it, so it is waiting for a commit or rollback from us.<\/p>\n
Let’s end our relevant transaction by committing and check if our table is created.<\/p>\n
![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/begin3.png\")
<\/p>\n
After committing the table in the window where we created it, we check it by clicking refresh on Tables and see that it has been created.<\/p>\n
If a commit was made, this table would be considered as if it had never been created and the transaction would be terminated.<\/p>\n
We understand commit and rollback, but what is savepoint?<\/p>\n
Let’s say you made three transactions in the savepoint command transaction, but you want to return to the second transaction, you can return to that transaction by typing savepoint_name.<\/p>\n
Let’s reinforce it with an example.<\/p>\n
![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/begin4.png\")
<\/p>\n
Above, we created a table named trial in a single transaction and added the data in this transaction.<\/p>\n
After making two inserts, we made a savepoint and added another insert sentence. After that, since we did not want to make the last insert, we came to the save point we created using the “rollback to point” command. When we query, we see that only the first two data have been added.<\/p>\n
![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/begin5.png\")
<\/p>\n
We saw the data with Select*from, but we still do not have a table named trial. This is because we did not commit, so we returned to the savepoint with rollback, but we need to commit in order for it to be written in the other table creation and insert sentences.<\/p>\n
![](\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/begin6.png\")
<\/p>\n
After the commit, our table is created and we see the data added.<\/p>\n