[Quote]
mysql> select * from proc \G
*************************** 1. row ***************************
db: csdn
name: testdata
type: PROCEDURE
specific_name: testdata
language: SQL
sql_data_access: CONTAINS_SQL
is_deterministic: NO
security_type: DEFINER
param_list:
returns:
body: begin
declare i int;
set i = 0;
while i <5000000
do
insert into tb_myisam(name) values(ceil(rand()*100));
set i = i + 1;
end while;
end
definer: root@localhost
created: 2011-09-04 23:37:47
modified: 2011-09-04 23:37:47
sql_mode:
comment:
character_set_client: latin1
collation_connection: latin1_swedish_ci
db_collation: latin1_swedish_ci
body_utf8: begin
declare i int;
set i = 0;
while i <5000000
do
insert into tb_myisam(name) values(ceil(rand()*100));
set i = i + 1;
end while;
end
1 row in set (0.00 sec)