Re: Temporary Tables Aliasing in Stored Procedure

[Roland Bouman]

Andrew Gilfrin wrote:
> My reply was aimed more at Conor rather than you
> Roland.

Well, I'ts helping me out too.

> Nothing stopping you creating a table in the db,
> using it in the procedure and then dropping it
> later. If it's something you will be runnig alot
> then a premanent temporary table will do the
> trick.

Yep, that's what I gathered from your article at http://mysqldevelopment.com

> I think what MySQL Stored Procedures need is some
> sort of complex data structure such as a
> 'temporary' structure or a multi dimentional
> array.

I agree, would be nice, although there's nothing you can't do with just (temporary) database tables, or is there?