2
SET @@storage_engine = 'Falcon';
3
DROP TABLE IF EXISTS tj9;
4
DROP PROCEDURE IF EXISTS pj9;
5
CREATE TABLE tj9 (s0 int);
6
create procedure pj9 ()
8
declare v int default 1;
11
set @v = concat('alter table tj9 add column s',v,' char(64) default ''Hello World''');
12
prepare stmt1 from @v;
19
insert into tj9 (s1) values (v);
25
set @v = concat('update tj9 set s',v,'=concat(s2,s1)');
26
prepare stmt1 from @v;
3026
SELECT count(*) FROM t1;