|
#1
03-30-2008, 06:45 AM
|
|||
|
|||
MySQL - Saving SQL, procedures and functions
Hello,
Does anybody know if you can save custom SQL queries in MySQl? I could save them locally but is there somewhere on the server in MySQL I can save them? Also, are we allowed to create and store custom procedures and functions? Thanks, John 
|
|
#2
03-30-2008, 10:03 AM
|
||||
|
||||
|
Re: MySQL - Saving SQL, procedures and functions
If you're on a MySQL 5 server you should be able to use views, which are essentially stored queries returned and query-able as quasi-tables. Is that what you're looking for?
__________________
Follow me on Twitter! http://twitter.com/mrw
|
|
#3
03-30-2008, 02:09 PM
|
||||
|
||||
|
Re: MySQL - Saving SQL, procedures and functions
You can serialize your queries and store them as files or in a database.
http://us2.php.net/manual/en/function.serialize.php
|
 |
| Bookmarks |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
|
|
All times are GMT -5. The time now is 05:50 PM.