56,677
社区成员
发帖
与我相关
我的任务
分享
DECLARE @a int,@tname char
set @a =1;
set @tname = 'test';
WHILE @a <= 10
begin
@tname = @tname + @a;
insert into testTable(username,userpwd) values (@tname,'a');
@tname ='test';
@a = @a +1;
end;
mysql> select * from cdr;
Empty set (0.00 sec)
mysql> drop procedure add_date;
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter $$
mysql> create procedure add_date()
-> begin
-> declare i int default 0;
-> while i<=10 do
-> insert into cdr(id,userfield) values(i,'a');
-> set i=i+1;
-> end while;
-> end;$$
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql> call add_date();
Query OK, 1 row affected (0.39 sec)
mysql> select * from cdr;
+------+-----------+
| id | userfield |
+------+-----------+
| 0 | a |
| 1 | a |
| 2 | a |
| 3 | a |
| 4 | a |
| 5 | a |
| 6 | a |
| 7 | a |
| 8 | a |
| 9 | a |
| 10 | a |
+------+-----------+
11 rows in set (0.00 sec)