Chriss,
> I'm trying to create a flatfile dump from our database which requires some
> functionality that's not possible with raw sql. Up to now we've been
using
> PHP tied to mySql to do all the work and get the data in the correct
format.
> We would like to switch this functionality over to stored procedures in
> mySql. My question is this: Is it possible to hook a series of stored
> procedures to a view so that the data is live and current?
What do you mean by that?
A view is always current.
Can you explain it a bit better?
>We could set it
> up to run our procedures on some regular interval and dump the result into
a
> temporary table but having up-to-date data would be ideal.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
