DexterJones
asked on
You can't specify target table 'member' for update in FROM clause
Hi,
Please kindly assist how can we resolve this error? mysql 5
Thanks.
Error Code : 1093
You can't specify target table 'member' for update in FROM clause
(0 ms taken)
(1 row(s) returned)
(0 ms taken)
CREATE PROCEDURE ``.`sp_add` (
IN vstartdate varchar(10),
IN venddate varchar(10),
IN vid int,
)
BEGIN
update member set Enddate=date_add(str_to_da te(vstartd ate,'%m/%d /%Y'), interval -1 day) where id=vid
and startdate = (select max(startdate) from member where id=vid);
END$$
DELIMITER ;$$
Please kindly assist how can we resolve this error? mysql 5
Thanks.
Error Code : 1093
You can't specify target table 'member' for update in FROM clause
(0 ms taken)
(1 row(s) returned)
(0 ms taken)
CREATE PROCEDURE ``.`sp_add` (
IN vstartdate varchar(10),
IN venddate varchar(10),
IN vid int,
)
BEGIN
update member set Enddate=date_add(str_to_da
and startdate = (select max(startdate) from member where id=vid);
END$$
DELIMITER ;$$
opps sorry, just not ny day
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
u'd a extra comma after the last argument and u need a space after defining it as day
CREATE PROCEDURE `test`.`sp_add`(IN vstartdate varchar(10), IN venddate varchar(10),IN vid int)
BEGIN
update member set Enddate=date_add(str_to_da
where id=vid and startdate = (select max(startdate) from member where id=vid);
END