saving mysql queries

I'm a newbie so please bear with me. I need to know how to save a query as a table. Can anyone help?

Thank you!
X

Comments

  • : I'm a newbie so please bear with me. I need to know how to save a query as a table. Can anyone help?
    :
    : Thank you!
    : X
    :
    Hi!

    I'm a little confused with your question. Since a query acts on a table, why would you store it in the table?

    Maybe you need to save the query as a stored procedure?

    Or do you just want the text of the query to be stored? If so, you could just put it into a text column.

    Maybe if you post with more info?


  • : : I'm a newbie so please bear with me. I need to know how to save a query as a table. Can anyone help?
    : :
    : : Thank you!
    : : X
    : :
    : Hi!
    :
    : I'm a little confused with your question. Since a query acts on a table, why would you store it in the table?
    :
    : Maybe you need to save the query as a stored procedure?
    :
    : Or do you just want the text of the query to be stored? If so, you could just put it into a text column.
    :
    : Maybe if you post with more info?
    :
    Sorry I wasn't clear. Lets say I run a simple query like:
    SELECT FNAME, LNAME
    FROM Employee
    WHERE DEPARTMENT='5'

    I want to save the resulting query that I get from that
    Thank you for your time.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories