mysql資料庫函數

標籤：

BEGINDECLARE diff, x INT;SET diff =0;SET x = 10072;WHILE (x  < 40070 )  DOinsert into order_info( id, sale_area_id , type_dic , `code` , pay , real_pay , consignee , consignee_address , consignee_tel , consignee_poscode , status_dic , order_time , send_time , logistic_id , transport_cost , discount_cost , refund_cost , factorage_cost , other_cost , other_cost1 , other_cost2 , other_cost3 , other_cost4 , order_cost , cost_adjustment, profit , currency_dic , free_shipping_dic , customer_id , purchase_ip , curement_track_num , remark , orderby , create_time , modify_time , salesman_id , operator_id , verify_id , sys_org_id , pay_type_dic , pay_dic , purchase_dic , send_dic , parent_id , need_invoice_dic , has_create_dic , invoice_head , invoice_type_dic , dc_org_code , dc_user_code , dc_tenant_code , payment_person, order_source ) values( x,11 , 1 , ‘ds7878‘ , 27.0 , 27.0 , ‘Christy‘ , ‘北京市懷柔區‘ , 15076585230 , 121210 , 1 , ‘2016-08-10 19:15:29‘ , ‘2016-08-10 19:15:50‘ , null, 0.0 , 0.0 , 0.0 , 0.0 , 0.0 , null, null, null, null, 26.0 , 0.0 , 1.0 , 1 , null, 3 , null, null ,null  , null, ‘2016-08-10 19:15:50.76‘ , ‘2016-08-10 19:15:50‘ , 1 , 1 , null, 1 , null, null, null, null, null, null, null, null, null, 01 , 0001 , null, null , 1 ); insert into order_product( order_id , type_path , product_id , barcode , purchase_quantity , purchase_price , purchase_sum , remark , orderby ,  var_group, price_id ) values( x , 1 , 46 , null, 1.0 , 15.0 , 15.0 , null, null, null , ‘131‘ );insert into order_product( order_id , type_path , product_id , barcode , purchase_quantity , purchase_price , purchase_sum , remark , orderby , var_group, price_id ) values( x , 1 , 45 , null, 1.0 , 12.0 , 12.0 , null, null, null , ‘130‘ ); insert into order_send( order_id , code , sys_logistic_id , transport_dic , tracking_number , transport_cost , send_type_dic ,  send_linkman , send_poscode , send_tel , send_address , name , tel , country , city , email , address , postcode , area , remark , create_time , modify_time , salesman_id , operator_id , verify_id , sys_org_id , dc_org_code ,  dc_user_code , dc_tenant_code )  values( x , ‘ds7878‘ , null, null, null , null, null, ‘超級管理員‘ , null , ‘18911489015‘ ,   null, null, null, null, null, null, null, null, null, null , ‘2016-08-10 19:15:50‘ , ‘2016-08-10 19:15:50‘ , null, null, null, null, null, null, null);insert into order_opt( id , order_id , code , status_dic , customer_id , customer_name , operator_id , operator_name , operator_ip , operation , result , remark , create_time , sys_org_id ) values(  null, x, null, 1, 3, ‘Christy‘, null, ‘超級管理員‘, null, ‘新單‘, null, null, ‘2016-08-10 19:15:51.603‘, null);SET x = x+1;END WHILE;  RETURN x;END

 

mysql資料庫函數