Question

mysql写存储过程对单表插入测试数据，出问题

就是不能执行

Answer 1

什么问题啊？？？大妹子，错误提示和存储过程代码贴出来

追问

create procedure doInsert()
begin
declare i int;
SET i=24;
loop1: WHILE i<=199 DO
insert into flow (flow_record_id, lin_id, user_id, statistic_type, packets, bits, pps, bps, time_start,time_end,time_type,seconds)
values (i, 1, 1, 1, 2000, 3000,600,7000, '2012-01-02 07:00:00', '2012-01-02 07:00:00',1, 1);
SET i=i+1;
END WHILE loop1;
end;
call doInsert();-- 调用存储过程

Answer 2

把你的表给我看看，想插入什么数据

追问

这是表的结构