> 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
> PHP tied to mySql to do all the work and get the data in the correct
> 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
> temporary table but having up-to-date data would be ideal.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!