题目:有1、2、3、4个数字,能组成多少个互不相同且无重复数字的三位数?都是多少?
drop PROCEDURE if exists test;
create PROCEDURE test( )
BEGIN
declare i int;
declare j int;
declare k int;
create TEMPORARY table ttt(A int);
set i=1;
while i<=4 do
set j=1;
while j<=4 DO
set k=1;
while k<=4 DO
if i<>j and i<>k and j<>k THEN
insert into ttt values(i*100+j*10+k);
end if;
set k=k+1;
end while;
set j=j+1;
end while;
set i=i+1;
end while;
select * from ttt;
drop table ttt;
end;