MySQL database functions

begindeclare diff, X INT; SET diff=0; SET x= 10072; while (x< 40070) Doinsert into Order_info (IDs, 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, R Efund_cost, Factorage_cost, Other_cost, Other_cost1, Other_cost2, Other_cost3, Other_cost4, Order_cost, Cost_adjus Tment, Profit, Currency_dic, Free_shipping_dic, customer_id, Purchase_ip, Curement_track_num, remark, by-and-CRE Ate_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_t Enant_code, Payment_person, Order_source) VALUES (x,One, 1, ' ds7878 ', 27.0, 27.0, ' Christy ', ' Beijing Huairou ' , 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, 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, Purch Ase_sum, remark, 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_d IC, Send_linkman, Send_poscode, Send_tel, Send_address, name, tel, country, city, email, address, postcode, a REA, remark, Create_time, Modify_time, salesman_id, operator_id, verify_id, sys_org_id, Dc_org_code, dc_user_cod E, Dc_tenant_code) values (x,' ds7878 ',NULL,NULL,NULL , NULL,NULL, ' super admin ',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,NULLINSERT 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 (NULLXNULL, 1, 3, ' Christy ',NULL, ' super admin ',NULL, ' new single ',NULL,NULL, ' 2016-08-10 19:15:51.603 ',NULL); SET x= X+1;  END while; RETURN x; END

MySQL database functions