CREATE PROCEDURE `createEmpAndEpost`(
IN _ename varchar(225) character set utf8,
IN _password varchar(25),
IN _sex int(1),
IN _birthDate datetime,
IN _telephone varchar(25),
IN _eDate datetime,
IN _pno int(11))
begin
insert into emp(`ename`, `password`, `sex`, `birthDate`, `telephone`, `eDate`)
values(_ename, _password, _sex, _birthDate, _telephone, _eDate);
select @eno:= LAST_INSERT_ID();
insert into epost(`eno`,`pno`) values(@eno, _pno);
end;运行出错: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 8
IN _ename varchar(225) character set utf8,
IN _password varchar(25),
IN _sex int(1),
IN _birthDate datetime,
IN _telephone varchar(25),
IN _eDate datetime,
IN _pno int(11))
begin
insert into emp(`ename`, `password`, `sex`, `birthDate`, `telephone`, `eDate`)
values(_ename, _password, _sex, _birthDate, _telephone, _eDate);
select @eno:= LAST_INSERT_ID();
insert into epost(`eno`,`pno`) values(@eno, _pno);
end;运行出错: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 8
解决方案 »
- mysql有没有数据库附加的功能
- mysql 查询时遇到的奇怪的问题!求高手解决!
- [问个小问题6-- ...denied for user 'ODBC'@'localhost']
- MYSQL中数据记录15亿条...
- mysql现在还有免费的版本吗?
- MySql中数据类型更改的一些问题
- 请问游标定义之前能不能做其它删除、插入操作?二级游标能不能动态定义?
- MySQL有存储过程和视图吗?
- 我的win2000装在d盘,c盘装的win xp,我的mysql安装在d;\mysql下,mysql无法运行,怎么呢?!
- 求助,mysql触发器的问题
- mysql从服务器备份到本地
- 内网mysql服务器与外网mysql服务器互为主从同步问题
CREATE PROCEDURE `createEmpAndEpost`(
IN _ename varchar(225) character set utf8,
IN _password varchar(25),
IN _sex int(1),
IN _birthDate datetime,
IN _telephone varchar(25),
IN _eDate datetime,
IN _pno int(11))
begin
insert into emp(`ename`, `password`, `sex`, `birthDate`, `telephone`, `eDate`)
values(_ename, _password, _sex, _birthDate, _telephone, _eDate);
select @eno:= LAST_INSERT_ID();
insert into epost(`eno`,`pno`) values(@eno, _pno);
end;
//
DELIMITER $$
CREATE PROCEDURE `createEmpAndEpost`(
IN _ename VARCHAR(225) CHARACTER SET utf8,
IN _password VARCHAR(25),
IN _sex INT(1),
IN _birthDate DATETIME,
IN _telephone VARCHAR(25),
IN _eDate DATETIME,
IN _pno INT(11))
BEGIN
INSERT INTO emp(`ename`, `password`, `sex`, `birthDate`, `telephone`, `eDate`)
VALUES(_ename, _password, _sex, _birthDate, _telephone, _eDate);
SELECT @eno:= LAST_INSERT_ID();
INSERT INTO epost(`eno`,`pno`) VALUES(@eno, _pno);
END$$
DELIMITER ;