还是不对 错误提示是什么?[SQL] CREATE DEFINER = CURRENT_USER PROCEDURE `NewProc`(IN `pagesize` int,IN `pageindex ` int,IN `docoutn` bit,IN `customername` varchar,IN `customerid` varchar,IN `cellphone` varchar,IN `tellphone` varchar) BEGIN select * from crm_customerEND;; ; [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN `customerid` varchar,IN `cellphone` varchar,IN `tellphone` varchar) BEGIN s' at line 1
可以了哦 我直接这样写的就可以创建了 CREATE PROCEDURE proc_22(IN `pagesize` int) BEGIN select * from crm_customer; END;
BEGIN
select * from crm_customerEND;;
//
delimiter ;
错误提示是什么?[SQL] CREATE DEFINER = CURRENT_USER PROCEDURE `NewProc`(IN `pagesize` int,IN `pageindex ` int,IN `docoutn` bit,IN `customername` varchar,IN `customerid` varchar,IN `cellphone` varchar,IN `tellphone` varchar)
BEGIN
select * from crm_customerEND;;
;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN `customerid` varchar,IN `cellphone` varchar,IN `tellphone` varchar)
BEGIN
s' at line 1
我直接这样写的就可以创建了
CREATE PROCEDURE proc_22(IN `pagesize` int)
BEGIN
select * from crm_customer;
END;