From: Martijn Tonies
Date: March 24 2006 6:26pm
Subject: Re: Stored procedures and views
List-Archive: http://lists.mysql.com/mysql/196136
Message-Id: <025701c64f70$6ea3fc50$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="windows-1250"
Content-Transfer-Encoding: 7bit

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