Mysql stored procedure

Databases
1

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

2

how can we see your query? please show us

1 Like
3 
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

4

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