sql - What does COMMIT do? -


please want understand difference between folowing 2 statements:

insert table_name values (,,,,,); 

and

insert table_name values (,,,,,); commit; 

if insert data without commit can select data database , see it. other users can't.

it's better sql documentation:

until commit transaction:

you can see changes have made during transaction querying modified tables, other users cannot see changes. after commit transaction, changes visible other users' statements execute after commit.

you can roll (undo) changes made during transaction rollback statement (see rollback.

for example here oracle documentation , info transactions


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -