Query

[UtOkbOlinAO]

Hi guys,

Lets assume nga naa moy isa ka table then with 20 colums..

how do u construct a query that would select all 19 colums pero dili i.explicit ug apil sa query ang column name...

in short "select * except a column" how to do this?

Thanks guys in advance...

[xeoxander01]

SQL ni dong?.. ang solutions ani kay ayaw pag tinapulan... i explicitly specify nimo kung unsa ra imong i apli.. kung ganahan jud kag mo gamit og select all (*), hala pag create og view nga mo exclude atong column ng di nimo ganahan i apil sa query nya adto pag select all...

hina-ut nka tabang ko dong.. cheers!

[clarkhkent]

google daw rold

[kolz]

you can use the result of this statement:

show columns from <tablename> where field not in ('field-to-skip', 'field-to-skip2');

to your select statement dynamically ...

try it out, not sure if that would work though.

[UtOkbOlinAO]

you can use the result of this statement:

show columns from <tablename> where field not in ('field-to-skip', 'field-to-skip2');

to your select statement dynamically ...

try it out, not sure if that would work though.

bro, thanks for the post but it doesnt work also...

[raybanz21]

google daw rold

nice suggestion. simple but straight to the point. nice work brad. lolz...

@utok..

dali ra na. i drop na lang tanang table. hehehe.. jok lang...
mapangitaan lagi na ug pa agi...

[UtOkbOlinAO]

nice suggestion. simple but straight to the point. nice work brad. lolz...

@utok..

dali ra na. i drop na lang tanang table. hehehe.. jok lang...
mapangitaan lagi na ug pa agi...

mao rani akong gikinahanglan

SELECT COLUMN_NAME
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = XTABLE
AND COLUMN_NAME <> XCOLUMN

[psyd_1]

lisura ani oi...hehehehe

[dodie]

Hi guys,

Lets assume nga naa moy isa ka table then with 20 colums..

how do u construct a query that would select all 19 colums pero dili i.explicit ug apil sa query ang column name...

in short "select * except a column" how to do this?

Thanks guys in advance...

LAZY CODES ARE BAD CODES!!!!!! :P

No, it's not advisable. It will cause future problems with your table.
Firstly, as a programmer or developer, you have to know all columns write them down and include them in your query and exclude the column you don't like to be part of your query.

SELECT c1,c2,     c4,c5,c6,c7
FROM stupidtable
WHERE blah blah AND BLAH BLAH and blah blah
GROUP BY blah blah
ORDER BY blah blah
LIMIT blah blah

If you create a special function or method that exclude your keyword from the query. It's possible.

[psyd_1]

LAZY CODES ARE BAD CODES!!!!!! :P

No, it's not advisable. It will cause future problems with your table.
Firstly, as a programmer or developer, you have to know all columns write them down and include them in your query and exclude the column you don't like to be part of your query.

i would not consider UtOkbOlinAO's post as a bad nor lazy.. i guess he's just looking for a simple approach in SQL's field of computing.. and since its not yet there, then maybe someone could push the idea - bring it to the public and say, "hey heroes! here's a new technique in querrying something like 'construct a query that would select all 19 colums pero dili i.explicit ug apil sa query ang column name' "....now that's computing..now that computer science!