Hi all,
I have a problem here and looking for a solution.
I have a temporary table which is a smaller table generated from a
rather big one. The full table is too big to make real gimmicks on it,
so I do need the temp table. Later I need to do several queries on the
temp table.
So my initial setup and needs are:
- temporary table to work from
- result sets derived from parametric queries
- mysql views cannot work from temporary tables so I have to drop a
view+select/where approach.
- functions cannot return result sets
- procedures can do everything but I found no way to handle the result
set within mysql (officially not supported)
Any ideas how to solve this?
Thanks in advance
Bgs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
