· 7 years ago · Feb 04, 2019, 04:32 PM
1drop procedure test_proc;
2delimiter $$
3
4create procedure test_proc(IN id int, IN nam varchar(50))
5begin
6
7CREATE TEMPORARY TABLE IF NOT EXISTS tst
8as
9(select id, nam);
10
11select * from tst;
12truncate table tst;
13end$$
14
15delimiter ;
16
17
18
19call test_proc(7,'dasda');
20call test_proc(8,'olololo');
21call test_proc(9,'hgfhfghfhgf');