I have created procedure through migration but its not throwing any result when I am passing string in where query. Here is my code
CREATE PROCEDURE my_procedure( IN _searchStr VARCHAR(100) ) BEGIN SELECT * FROM user WHERE user.name=_searchStr; END
If I pass hardcode value in place of _searchStr then its showing result?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire