å建åå¨è¿ç¨
CREATE PROCEDURE åå¨è¿ç¨å()
ä¸ä¸ªä¾å说æï¼ä¸ä¸ªè¿å产åå¹³åä»·æ ¼çåå¨è¿ç¨å¦ä¸ä»£ç ï¼
CREATE PROCEDURE productpricing()
BEGIN
SELECT Avg(prod_price) AS priceaverage
FROM products;
END;
//å建åå¨è¿ç¨å为productpricingï¼å¦æåå¨è¿ç¨éè¦æ¥ååæ°ï¼å¯ä»¥å¨ï¼ï¼ä¸å举åºæ¥ãå³ä½¿æ²¡æåæ°åé¢ä»ç¶è¦è·ï¼ï¼ãBEGINåENDè¯å¥ç¨æ¥éå®åå¨è¿ç¨ä½ï¼è¿ç¨ä½æ¬èº«æ¯ä¸ªç®åçSELECTè¯å¥
温馨提示:答案为网友推荐,仅供参考