一開(kāi)始用phpMyAdmin來(lái)執(zhí)行，后來(lái)出現(xiàn)一堆錯(cuò)誤，后來(lái)去掉了begin,end之后可以正常執(zhí)行，但要執(zhí)行存儲(chǔ)過(guò)程，在phpMyAdmn中不行，而在mysql命令行文本框中就可以。
接下來(lái)又遇到更難的問(wèn)題，在存儲(chǔ)過(guò)程中加入預(yù)處理語(yǔ)句，更不行了，在mysql命令行文本框下執(zhí)行同樣，下面的運(yùn)行記錄，給大家參考，能否有高手來(lái)幫助。

//原本的存儲(chǔ)過(guò)程語(yǔ)句
EATE PROCEDURE catalog_get_products_in_category(
IN inCategoryId INT, IN inShortProductDescriptionLength INT,
IN inProductsPerPage INT, IN inStartItem INT)
BEGIN
PREPARE statement FROM
"SELECT p.product_id, p.name,IF(LENGTH(p.description) <= ?, p.description,
CONCAT(LEFT(p.description, ?),'...')) AS description, p.price, p.discounted_price, p.thumbnail
FROM product p INNER JOIN product_category pc ON p.product_id = pc.product_id
WHERE pc.category_id = ?
ORDER BY p.display DESC
LIMIT ?, ?";
SET @p1 = inShortProductDescriptionLength;
SET @p2 = inShortProductDescriptionLength;
SET @p3 = inCategoryId;
SET @p4 = inStartItem;
SET @p5 = inProductsPerPage;
EXECUTE statement USING @p1, @p2, @p3, @p4, @p5;
END$$

mysql> delimiter $$
mysql> CREATE PROCEDURE catalog_get_products_in_category(
-> IN inCategoryId INT, IN inShortProductDescriptionLength INT,
-> IN inProductsPerPage INT, IN inStartItem INT)
-> BEGIN
-> PREPARE statement FROM
-> "SELECT p.product_id, p.name,IF(LENGTH(p.description) <= ?, p.descript
ion,
"> CONCAT(LEFT(p.description, ?),'...')) AS description, p.price, p.disco
unted_price, p.thumbnail
"> FROM product p INNER JOIN product_category pc ON p.product_id = pc.pro
duct_id
"> WHERE pc.category_id = ?
"> ORDER BY p.display DESC
"> LIMIT ?, ?";
-> SET @p1 = inShortProductDescriptionLength;
-> SET @p2 = inShortProductDescriptionLength;
-> SET @p3 = inCategoryId;
-> SET @p4 = inStartItem;
-> SET @p5 = inProductsPerPage;
-> EXECUTE statement USING @p1, @p2, @p3, @p4, @p5;
-> END$$
ERROR 1314 (0A000): PREPARE is not allowed in stored procedures

上面有兩個(gè)存儲(chǔ)過(guò)程，一個(gè)不用預(yù)處理語(yǔ)句，一個(gè)用了預(yù)處理語(yǔ)句，
之后，向作者發(fā)過(guò)郵件，沒(méi)有答復(fù)，又給mysql官方發(fā)過(guò)郵件，同樣沒(méi)答復(fù)?，F(xiàn)今只能求助諸位高人。