mysql procedure 小例子

create table user
(
    id int not null,   
    primary key(id)
)

 

LOAD data local infile 'G:/Mysql/user.txt' into table user lines terminated by '\r\n';

 

create procedure stats(out num int)
begin
select count(*) into num from user;
end

 

call stats(@num);

select @num;