From: Martijn Tonies
Date: March 17 2009 2:17pm
Subject: Re: Does MySQL 5.1 store queries?
List-Archive: http://lists.mysql.com/mysql/216756
Message-Id: <03d201c9a70b$2b85aef0$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit



> Until recently I have been using 4.0.25 and have just upgraded to 5.1  
> and just wondered if MySQL now enabled me to store queries in the  
> database rather than have to put them all on my pages. Basically, I  
> want to be able to write some select statements and save them in the  
> database.

That depends how you look at it...

Do you want VIEWs? If so, then yes.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com