我需要一点帮助。我在mysql中有三个表。
产品
客户
销售价格
通常我在我的经典asp文件的底部有查询。

set rs1=db.execute("Select id from customers order by id desc")

DO WHILE NOT rs1.EOF

set rs2=db.execute("Select id from products where order by id desc")

DO WHILE NOT rs2.EOF 

set rs3=db.execute("Select id from sellingprices where product_id="&rs2("id")&" and customer_id="&rs1("id")&" and status=1")
if rs3.eof then
db.Execute("INSERT INTO selling prices (price,product_id,status,customer_id) VALUES ('0','"&rs2("id")&"','1','"&rs1("id")&"');")
end if

rs3.close
Set rs3= Nothing

rs2.MoveNext
LOOP
rs2.close
Set rs2= Nothing

rs1.MoveNext
LOOP
rs1.close
Set rs1= Nothing

我的问题是如何用mysql创建存储过程？