pranithan-kang · February 2, 2024 09:47
diff --git a/rdbms-transaction-experimental.sql b/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;