Hi everyone ,there is a big question I got on how to resovle

dongyingying · Post by **dongyingying** » Fri Apr 27, 2012 7:31 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 28, 2012 1:48 am

Surely the SQL statement mentions the column(s) involved?

dongyingying · Post by **dongyingying** » Sat Apr 28, 2012 2:05 am

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 .

chulett · Post by **chulett** » Sat Apr 28, 2012 7:34 am

Sorry, but I have absolutely no idea what you are trying to ask or do.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 28, 2012 3:23 pm

Can you post the SQL statement? It does not matter if any constants in the SQL statement are Chinese.

chulett · Post by **chulett** » Sat Apr 28, 2012 5:16 pm

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?