can I run SQL on an existing query?

[KJS2002]

I'm querying mySQL tables quite happily from a Java application but ....
If a create a query in mySQL itself can I then save it somewhere on the server and then run a query on that saved query!

... or would it be best to just build the entire query into one SQL statement and run that from the client.

(Basically I can't work out how/where mySQL saves queries and how to point to them.)

 

[piti]

i don't think mysql provides such functionality
you'll need to create the complete sql statement and with it query the server

 

[KJS2002]

i thought that was probably the case. thanks.

 

[Addola]

Hmmm I am quite a newbie with MySQL , but if that was the case with Standard SQL, you could create a VIEW. It's like a saved query. I did that on Oracle I don't know if that would be applicable in MySQL

check this out :

http://www.mckoi.com/database/SQLSyntax.html#5