mysql函数创建 ? delimiter $$create function fungetskucontractorid(param_sku_number varchar(32)) returns int(11)begindeclare contraactor_id_temp,parent_id_temp, i int;set i=0;select max(contractor_id) , max(parent_id) into contraactor_id_tem
mysql函数创建?
delimiter $$ create function fungetskucontractorid(param_sku_number varchar(32)) returns int(11) begin declare contraactor_id_temp,parent_id_temp, i int; set i=0; select max(contractor_id) , max(parent_id) into contraactor_id_temp, parent_id_temp from erp$pro$product_sku ps join erp$pro$product p on ps.product_id = p.product_id join erp$pro$product_category pc on p.product_id = pc.product_id join erp$pro$category c on pc.category_id = c.category_id where ps.sku_number = param_sku_number ; /* * 因为现在分类最多只有四级，所以最多循环4次 */ while (i【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！