Hi all,
I have run a batch file contains,
mysql -uroot -proot -Dsample_db < "create_sp. sql"
The "create_sp. sql" file contains definition for the stored procedure by the name get_account_det ails()
Now i opened SQLyog and when I executed get_account_det ails() it generates error with message "zero rows fetched, selected, or processed"
But when i move to particular procedure and say alter,
without making any change i will click on execute querry button to alter the procedure.
Now when I call the sp get_account_det ails(), it returns me some output without any error.
What is the reason for this error, when i create procedure using, mysql -uroot -proot -Dsample_db < "create_sp. sql" ?
And how do I solve this problem, because i dont want to again open the SQLyog and locate the sp and run it again ?.
I have run a batch file contains,
mysql -uroot -proot -Dsample_db < "create_sp. sql"
The "create_sp. sql" file contains definition for the stored procedure by the name get_account_det ails()
Now i opened SQLyog and when I executed get_account_det ails() it generates error with message "zero rows fetched, selected, or processed"
But when i move to particular procedure and say alter,
without making any change i will click on execute querry button to alter the procedure.
Now when I call the sp get_account_det ails(), it returns me some output without any error.
What is the reason for this error, when i create procedure using, mysql -uroot -proot -Dsample_db < "create_sp. sql" ?
And how do I solve this problem, because i dont want to again open the SQLyog and locate the sp and run it again ?.
Comment