mysql:先在ysql中建一个查询,生成后打开proc5运行就可以了
**************************************************************************************************
DELIMITER //
CREATE PROCEDURE proc5()
begin
declare var int;
set var=0;
while var<600 do
insert into chushou
(QuXianId,XiaoQuName,JianZhuArea,Shi,Ting,Wei,ZongJia,CengShu,ZongCengShu,DaiKuan,Tel,ConnectUser,HouseClassId,ChanQuanId,ZhuanXiuId,BaShanId,JianZhuYear,JianZhuFangShiId,GongNuanId,PeiTaoSheShiId,JiaoTong,KanFangId,YouXiaoId,Content,SuoLueTu,ShiYongArea,ChaoXiangId,PubId,PubTime