MySQL‎ > ‎

Differences between stored procedures in mySQL and MS SQL Server

1)  To execute: 

call spGetReturns ('Inputparameter')

2)   Every line in your code has to end with a delimitter.  The default is a ;

3)   To set a variable equal to a value from a select statement you have to use :=

Select @variable:=value from table where