mysql存储过程例子

创建和使用存储过程
mysql> delimiter //
mysql> CREATE PROCEDURE load_part_tab()
begin
declare v int default 0;
loop1:while v < 7500000
do
INSERT INTO `member_search1` (`username`, `sex`, `height`, `weight`, `age`, `id_education`, `car`, `car_type`, `head_pic`, `pic_num`, `pengyou`, `login_times`, `regtime`, `login_time`, `lives`, `consumer`, `hobby`, `advantages`, `intention`, `requirements`, `industry`, `jobs`, `companname`, `address`, `city`, `district`, `address_work`, `city_work`, `district_work`, `lat`, `lng`, `lat_p`, `lat_work`, `lng_work`, `keys`, `status`, `display_status`) VALUES
('乌斯怀亚情种', 1, 170, 65, 28, 5, 1, '', 0, 0, 0, 1, 1275336065, 1275336065, 1, 1, '', '', '', '', '', '国企', '', '', '乌斯怀亚', '', '', '乌斯怀亚', '', -54.7916794, -68.229248, -54, -54.7916794, -68.229248, '乌斯怀亚情种国企', 2, 0);
set v = v + 1;
end while loop1;
end//
mysql> delimiter ;
mysql> call load_part_tab();
删除存储过程
mysql> drop PROCEDURE load_part_tab;

延伸阅读