Execute query which is fetched from a table using MySQL

[ssharma]

I am using ruby on rails.
Hence through my controller I am fetching the list of data(query strings saved in the database) on the basis of some condition. Now I need to execute these queries.
Do any one know how to do this?

[improvcornartist]

You should be able to execute the queries in the same way you fetch them. If not, you could maybe use something like DBI to connect to the database.

[ssharma]

hi improvcornartist,
I think you did'nt get me.
I am using MySql and I have a table where one column namely "action" contains certain queries.
Now, in controller I wrote a method which is able to fetch the data from the column but I want to execute the same.
What will the command for that in ruby on rails.
Thank you

[Rabbit]

They are saying that you can use the same command you use to fetch the data to execute the SQL string in the data that you fetched.

[ssharma]

no not at all we can't.
When the data is fetched from the table its just like a string fetching. Here, in the case the data fetched is in a query format itself eg( Select * from tablename). So, I need to apply the execution command on the data which is fetched through the method in the controller.

[Rabbit]

How are you executing the query that gets the data in the first place?

[Frinavale]

This thread has been closed because the question is to vague. If you have a specific question about how to use MySql with Ruby/Ruby On Rails please start a new thread with your question.