MySQL存储过程经典案例----九九乘法表 并且将表导出成为xls文件

九九乘法表

delimiter $$
create procedure lala( )
begin
declare a int;
declare b int;
declare c varchar(1000);
set a=1;
while a<=9 do
set c='';
set b=1;
while b<=a do
set c=concat(c,' ',a*b);
set b=b+1;
end while;
select c;
set a=a+1;
end while;
end $$
delimiter ;
call lala(