Why put COMMIT at the end of the script using the Firebird database

Asked

Viewed 1,309 times

3

Why in the Firebird database everything I do, including creating tables is necessary at the end of the script to give a command COMMIT?

sql firebird

  • What’s wrong with having to give a COMMIT?

2 answers

1

Firebird is a database transactional. It means that everything runs within a transaction.

Commit confirms changes made in the context of a transaction.

RollBack does the opposite, undoing the changes in the context of a transaction.

1

Answer:

The command COMMIT at the end of the script ensures that all instructions placed above it will be executed after the execution of that command. Using this command can avoid data inconsistency if a command in the middle of the script fails.

  • Do you have a way to disable this? In Mysql for example, it is not necessary.....

  • Mysql is not transactional.

Browser other questions tagged sql firebird

You are not signed in. Login or sign up in order to post.