Mysql stored procedure

Mysql Workbench select query or condition does not work properly . i am using id or name but one value does not retrive . if give two (id,name) values only display

how can i solve this problem? . please give me

how can we see your query? please show us

1 Like
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_select_detail`(IN venqid INT,In vsysdate varchar(50))
BEGIN
select * from `enq_details` where  sdate=vsysdate or enqid=venqid;

END

i need only sdate or enqid only values passed but here ask both two values otherwise error occured

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.