56,687
社区成员
发帖
与我相关
我的任务
分享
drop procedure if exists insertBatch;
create procedure insertBatch()
begin
select * from admininfo;
end;
drop procedure if exists insertBatch;
create procedure insertBatch()
begin
declare num int default 0;
end;
delimiter//
drop procedure if exists insertData;
delimiter//
create procedure insertData()
begin
declare num int default 0;
set num = 0 ;
while @num < 10 do
insert into phoenix.admininfo
values (null, 'test', 'test', 'test', 1, '1987-5-29', '1987-5-29', 'admin_email',
'admin_Mobile', 'admin_extension', 088, 0, phoenix, null, null, 0, 11);
set @num = @num + 1;
end while;
end;
mysql> delimiter //
mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
-> BEGIN
-> SELECT COUNT(*) INTO param1 FROM t;
-> END;
-> //