pranithan-kang/rdbms-transaction-experimental.sql

## rdbms-transaction-experimental.sql
create table abc (
	a int primary key,
	b text
) ;

begin transaction; -- begin transaction
	insert into abc (a, b) values (1, 'testing'); -- success
	insert into abc (a, b) values (1, 'testing2'); -- failed
	commit;	-- rollback
end; -- end transaction


drop table abc;
	create table abc (
	a int primary key,
	b text
	) ;

	begin transaction; -- begin transaction
	insert into abc (a, b) values (1, 'testing'); -- success
	insert into abc (a, b) values (1, 'testing2'); -- failed
	commit; -- rollback
	end; -- end transaction


	drop table abc;