solving a Simple SQL query

Question

Here is a tricky problem i am trying to solve, Having difficulty in solving it

Suppose there is a simple query::

String College="Harvard"

SELECT * FROM College

Above Harvard is the name of the table
College just has the value in it and is not the name of a table

Query will fail because system is assuming College as the name of the table and searching for it which is not there

How to solve this .... in terms of SQL statements

Hope i am clear

Thanks,

@ bksi .... Please can you post as the answers .... i didnt understan the query u posted ... sorry im a newbie — user2582071
– user2582071, Commented Aug 28, 2013 at 18:40
@Iplay:- I guess my answer is the one which you are looking for and which bksi also means!!! :) Hope this resolves your tricky query ;) — Rahul Tripathi
– Rahul Tripathi, Commented Aug 28, 2013 at 18:43

Rahul Tripathi · Accepted Answer · 2013-08-28 18:35:10Z

2

How about trying like this :)

SET @College:='Harvard';
SET @sql_text = concat('SELECT * FROM ', @College)

PREPARE stmt FROM @sql_text;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

answered Aug 28, 2013 at 18:35

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

GarethD Over a year ago

Should it not be SET @sql_text = concat('SELECT * FROM ', @College);

user2582071 Over a year ago

thanks .....that helps .... I posted this question to solve another problem i posted on site .... have a look at [stackoverflow.com/q/18495186/2582071] .... how can i apply there ... please give a feed back

Rahul Tripathi Over a year ago

You are welcome...I will try that question also!!! P.S. Dont forget to accept this as an answer if this helped you!!! :)

user2582071 Over a year ago

Please look into it .... even if you have not worked on express framework .... post your views on Mysql part of it , thanks

Rahul Tripathi Over a year ago

@Iplay:- And if that helps you too please dont forget to accept that as an answer too!!! :)

Collectives™ on Stack Overflow

solving a Simple SQL query

Here is a tricky problem i am trying to solve, Having difficulty in solving it

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Here is a tricky problem i am trying to solve, Having difficulty in solving it

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related