dimanche 10 septembre 2017

How to create stored procedures through migrations in laravel 5.3?

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