HI Team
in Memsql temporary table working so what different general temporary table if use commit and rollback
the data will go off… but in memsql after give commit in procedure also data is there…
i want to know more about temporary tables how it is working memsql in our document is not clear information…
i am using the below style of memsql give you comment
create or replace procedure tbl_test()
RETURNS void AS
DECLARE
v int = 0;
begin
begin
drop TEMPORARY TABLE tbl_xyz;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
end;
CREATE TEMPORARY TABLE tbl_xyz(sl_no int,sl_name varchar(10));loop
v = v+1;
EXIT WHEN v=50000;
insert into tbl_xyz values(v,concat(‘memsql’,v));commit;
end loop;
echo select count(*) from tbl_xyz;
delete from tbl_xyz;
end;