How do I use a MySQL Stored Procedure with Variables?

The SELECT INTO statement allows you to select into a variable. Is that what you are after? See here: dev.mysql.com/doc/refman/5.0/en/select-i... SELECT col_name , col_name ... INTO var_name , var_name ... table_expr.

Thank you for the message. These links helped me get part way there: kbedell. Com/2009/03/02/… and aschroder.Com/2009/03/… Thank you.

– Laxmidi Jun 17 '10 at 17:16.

I found a stored procedure that calculates whether a point is in a polygon or outside of it. But, I'm having a little trouble adapting it to my needs. I'd like to pull the the latitude and longitude from myPointsTable and set the @point to the result.

And then have the stored procedure iterate through those points. Likewise, I'd like to pull the polygon from myPolygonTable. How do I use a SELECT statement in setting the variables?

Is it possible? Is there a better way?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

How do I use a MySQL Stored Procedure with Variables?

Related Questions

How to call a stored procedure from another stored procedure in oracle?

Getting value from stored procedure in another stored procedure?

Stored Procedure runs slowly when being called from another stored procedure?

How to get the output value from stored procedure from another stored procedure in a tabular format?

Selecting multiple fields into multiple variables in a MySQL stored procedure?

Can a sub-procedure procedure lock and modify the same rows FOR UPDATE that its calling procedure already locked?