CREATEPROCEDUREINSERT_P()BEGINDECLAREiintdefault0;SET@i=0;WHILE@i<3DOINSERTINTOTB_BASE_CITY('ID','CITY_NAME','EN_NAME','COUNTRY_NAME','MODIFY_USER','MODIFY_DT','CREATE_US...
CREATE PROCEDURE INSERT_P()BEGIN DECLARE i int default 0; SET @i=0; WHILE @i<3 DO INSERT INTO TB_BASE_CITY('ID','CITY_NAME','EN_NAME','COUNTRY_NAME','MODIFY_USER','MODIFY_DT','CREATE_USER','CREATE_DT') VALUES (@i,'武汉','wuhan','1','admin','2016-7-4','admin','2016-7-4'); SET @i=@i+1; END WHILE;END;CREATE PROCEDURE INSERT_P()BEGIN DECLARE i int default 0; SET i=0; WHILE i<3 DO INSERT INTO TB_BASE_CITY('ID','CITY_NAME','EN_NAME','COUNTRY_NAME','MODIFY_USER','MODIFY_DT','CREATE_USER','CREATE_DT') VALUES (i,'武汉','wuhan','1','admin','2016-7-4','admin','2016-7-4'); SET i=i+1; END WHILE;END;CREATE PROCEDURE INSERT_P()BEGIN DECLARE i int ; SET @i=0; WHILE @i<3 DO INSERT INTO TB_BASE_CITY('ID','CITY_NAME','EN_NAME','COUNTRY_NAME','MODIFY_USER','MODIFY_DT','CREATE_USER','CREATE_DT') VALUES (@i,'武汉','wuhan','1','admin','2016-7-4','admin','2016-7-4'); SET @i=@i+1; END WHILE;END;以上加@,不加@都试过了 都报相同的语法错误
展开