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
?
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
?
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.
What’s wrong with having to give a
COMMIT
?– Maniero