List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:March 24 2006 6:26pm
Subject:Re: Stored procedures and views
View as plain text  
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


Thread
Foreign keysJoão Cândido de Souza Neto24 Mar
  • Re: Foreign keysOlusola Fadero24 Mar
    • Stored procedures and viewsChris Carrier24 Mar
      • Re: Stored procedures and viewsMartijn Tonies24 Mar
        • RE: Stored procedures and viewsChris Carrier24 Mar
          • Re: Stored procedures and viewsMartijn Tonies24 Mar
            • RE: Stored procedures and viewsGordon24 Mar