存储过程代码如下
DELIMITER $$;DROP PROCEDURE IF EXISTS `manage`.`sp_manage_permission_add`$$CREATE PROCEDURE `manage`.`sp_manage_permission_add`
(
@parentid INT,
@url varchar(200),
@type_ INT,
@menusql varchar(1000),
@mame varchar(50),
@description varchar(1000)
)
BEGIN INSERT INTO [test]
(
`parentid`,`description`,`url`,`type`,`menusql`,`mame`
)
VALUES
(
@parentid,@description,@url,@type_,@menusql,@mame
);
END$$DELIMITER ;$$
错误代码: 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 '@parentid INT,
@url varchar(200),
@type_ INT,
@menusql varchar(1000),
@mame ' at line 3
DELIMITER $$;DROP PROCEDURE IF EXISTS `manage`.`sp_manage_permission_add`$$CREATE PROCEDURE `manage`.`sp_manage_permission_add`
(
@parentid INT,
@url varchar(200),
@type_ INT,
@menusql varchar(1000),
@mame varchar(50),
@description varchar(1000)
)
BEGIN INSERT INTO [test]
(
`parentid`,`description`,`url`,`type`,`menusql`,`mame`
)
VALUES
(
@parentid,@description,@url,@type_,@menusql,@mame
);
END$$DELIMITER ;$$
错误代码: 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 '@parentid INT,
@url varchar(200),
@type_ INT,
@menusql varchar(1000),
@mame ' at line 3
(
parentid INT,
url varchar(200),
type_ INT,
menusql varchar(1000),
mame varchar(50),
description varchar(1000)
)
BEGININSERT INTO test
(`parentid`,`description`,`url`,`type`,`menusql`,`mame`)
VALUES
(
parentid,description,url,type_,menusql,mame
);
END$$DELIMITER ;$$
(
parentid INT,
url varchar(200),
type_ INT,
menusql varchar(1000),
mame varchar(50),
description varchar(1000)
)
BEGIN INSERT INTO `test`
(`parentid`,`description`,`url`,`type`,`menusql`,`mame` )
VALUES
( parentid,description,url,type_,menusql,mame );
END$$ DELIMITER ;$$