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

Question

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

Navigation

#1 by (1 votes)
#2 by (1 votes)

3

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

sql firebird

asked by anonymous 28.09.2016 / 02:44

2 answers

Pass parameters using the guzzle client How to plot a route using maps API

score 1 · Answer 1

Answer:

The COMMIT command at the end of the script ensures that all statements placed above it will run after executing this command. Using this command can prevent data inconsistency if any commands in the middle of the script fail.

score 1 · Answer 2

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

Commit confirms changes made in the context of a transaction.

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