Posted by IchBin on 09/28/17 11:53

talthen.z-serwera.o2@nospam.pl wrote:
> Hello,
> I have records that have many columns. Most of them are of type INT or
> VARCHAR, but a few columns are pretty big (TEXT) (like COLUMN1). When I do:
> SELECT * FROM TABLE
> it takes a lot of time, but I don't need data from COLUMN1 and don't want to
> write code like this:
> SELECT column2,column3,....column20 from TABLE
> I would rather do something like:
> SELECT (ALLCOLUMNS BUT COLUMN1) FROM TABLE
>
> How to write such thing for MySQL?
>
> Regards,
> Talthen
>
>

The only way I can think of doing the way you want is to create a VIEW.
In the view you have all of the columns you want.

Then just select * from the view.

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

[Back to original message]