示例: DELIMITER $$DROP PROCEDURE IF EXISTS `zz`.`PP`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `PP`() BEGIN declare ee int DeFAULT 1; while ee<=100 do set ee=ee+1; end while; END$$DELIMITER ;
我怎么执行不了,下边的对不? DELIMITER $$ CREATE DEFINER=`mytest`@`192.168.1.244` PROCEDURE `PP`() BEGIN declare ee int DeFAULT 1; while ee <=10000 do insert into table_1 values(i,i); set ee=ee+1; end while; END$$ DELIMITER ;
I是变量?没有定义,怎么使用 DELIMITER $$DROP PROCEDURE IF EXISTS `zz`.`PP`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `PP`() BEGIN declare ee int DeFAULT 1; while ee<=100 do insert into lsb2 values(ee); set ee=ee+1; end while; END$$DELIMITER ;
DELIMITER $$DROP PROCEDURE IF EXISTS `zz`.`PP`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `PP`()
BEGIN
declare ee int DeFAULT 1;
while ee<=100 do
set ee=ee+1;
end while; END$$DELIMITER ;
DELIMITER $$
CREATE DEFINER=`mytest`@`192.168.1.244` PROCEDURE `PP`()
BEGIN
declare ee int DeFAULT 1;
while ee <=10000 do
insert into table_1 values(i,i);
set ee=ee+1;
end while; END$$ DELIMITER ;
DELIMITER $$DROP PROCEDURE IF EXISTS `zz`.`PP`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `PP`()
BEGIN
declare ee int DeFAULT 1;
while ee<=100 do
insert into lsb2 values(ee);
set ee=ee+1;
end while;
END$$DELIMITER ;