VIP会员
购物车
私信
发表新帖
立即签到
关注
回复
支持(
反对(
首页上一页 1 下一页尾页 2 条记录 1/1页
php从入门到精通第19章，mysql建存储过程错误，请老师解答
发表在PHP图书答疑
2015-08-31
是否精华
是
否
版块置顶:
是
否
mysql存储过程语句：
drop procedure if exists pro_reg;
create procedure pro_reg (in nc varchar(80), in pwd varchar(80), in email varchar(80),in address varchar(50))
begin
insert into tb_reg (name, pwd ,email ,address) values (nc, pwd, email, address);
end;
错误如下：
SQL 查询:
CREATE PROCEDURE pro_reg( IN nc VARCHAR( 80 ) , IN pwd VARCHAR( 80 ) , IN email VARCHAR( 80 ) , IN address VARCHAR( 50 ) ) BEGIN INSERT INTO tb_reg( name, pwd, email, address )
VALUES (
nc, pwd, email, address
);
MySQL 返回：文档
#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 '' at line 3
drop procedure if exists pro_reg;
create procedure pro_reg (in nc varchar(80), in pwd varchar(80), in email varchar(80),in address varchar(50))
begin
insert into tb_reg (name, pwd ,email ,address) values (nc, pwd, email, address);
end;
错误如下：
SQL 查询:
CREATE PROCEDURE pro_reg( IN nc VARCHAR( 80 ) , IN pwd VARCHAR( 80 ) , IN email VARCHAR( 80 ) , IN address VARCHAR( 50 ) ) BEGIN INSERT INTO tb_reg( name, pwd, email, address )
VALUES (
nc, pwd, email, address
);
MySQL 返回：文档
#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 '' at line 3
分享到：
