Page 1 of 1
Hi everyone ,there is a big question I got on how to resovle
Posted: Fri Apr 27, 2012 7:31 pm
by dongyingying
I have a sql statement ,But I don't know the column before I run the sql,its means the sql is black box ,I know nothing in it ,before open it.,
So would you like tell me how to resolve the issue.
Posted: Sat Apr 28, 2012 1:48 am
by ray.wurlod
Surely the SQL statement mentions the column(s) involved?
Posted: Sat Apr 28, 2012 2:05 am
by dongyingying
Hi Ray ,we don't sure.the early ,I think it simple ,I change the row to column because the sql result only one row,yes it is. so I use the union word to change the sql .after all,I found there are some join or group ,so then my menthods is not correctly .
then I back to the source point .try to find a way the sql run first and then columns not needed ! but this is only my think , I don't know how to do .
Posted: Sat Apr 28, 2012 7:34 am
by chulett
Sorry, but I have
absolutely no idea what you are trying to ask or do.
Posted: Sat Apr 28, 2012 3:23 pm
by ray.wurlod
Can you post the SQL statement? It does not matter if any constants in the SQL statement are Chinese.
Posted: Sat Apr 28, 2012 5:16 pm
by chulett
dongyingying wrote:try to find a way the sql run first and then columns not needed !
Posting the sql involved should help. Are you saying that you don't know the "columns not needed" because it does a
select * rather than specifically naming the ones that are needed?