idtable :
CREATE TABLE `dsdvrdb`.`idtable` (
`ID` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetBiggestID`
(
out id bigint
)
BEGIN
declare @dd bigint;
select @dd=id from idtable limit 1;
set id=@dd;
END $$我只是想用存储过程得到查询的id,哪里错了?
CREATE TABLE `dsdvrdb`.`idtable` (
`ID` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetBiggestID`
(
out id bigint
)
BEGIN
declare @dd bigint;
select @dd=id from idtable limit 1;
set id=@dd;
END $$我只是想用存储过程得到查询的id,哪里错了?
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetBiggestID`
(
out oid bigint
)
BEGIN
declare dd bigint;
select id into dd from idtable limit 1;
set oid:=dd;
END $$
select id into @dd from idtable limit 1;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetBiggestID`
(
out id bigint
)
BEGIN
select @dd:=id from idtable limit 1;
set id=@dd;
END $$