0 votes
1 view
in SQL by (35.7k points)

Can anyone explain the commit in SQL?

1 Answer

0 votes
by (86.2k points)

Commit is a transactional control command that saves all the changes to the database that are made since the last COMMIT or ROLLBACK command. In simple words, COMMIT is used to save all the changes made by the transactions to the database.

Here is the syntax to use COMMIT command:

Commit;

Suppose you execute a query without commit command the changes won’t be published after the session is closed. If we use a query with COMMIT, the changes post the query will be saved successively.

You can check out this SQL Tutorial blog to learn more about transactional control commands.

Related questions

0 votes
1 answer
asked Aug 16 in SQL by Sudhir_1997 (35.7k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked May 7 in SQL by Sudhir_1997 (35.7k points)
0 votes
1 answer
asked May 7 in SQL by Sudhir_1997 (35.7k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...