Re: SELECT almost every column

2004-05-14 Thread Robert J Taylor
John Mistler wrote: Hmmm. The reason I asked was that the last column in the table is TEXT, and might contain up to 5000 text characters. I'm trying to make the query as efficient as possible, and I don't know if that much data will make a noticeable speed difference? Thanks, John on 5/14/04 2:31

Re: SELECT almost every column

2004-05-14 Thread John Mistler
Hmmm. The reason I asked was that the last column in the table is TEXT, and might contain up to 5000 text characters. I'm trying to make the query as efficient as possible, and I don't know if that much data will make a noticeable speed difference? Thanks, John on 5/14/04 2:31 PM, Justin Swanh

Re: SELECT almost every column

2004-05-14 Thread Justin Swanhart
--- John Mistler <[EMAIL PROTECTED]> wrote: > Is there a SELECT statement, if I have a table with > 50 columns, to select > every column EXCEPT the last one? Can I do this > without typing the name of > all 49 columns? > > If so, then what if I want to exclude the last TWO > columns? > > Thanks,

SELECT almost every column

2004-05-14 Thread John Mistler
Is there a SELECT statement, if I have a table with 50 columns, to select every column EXCEPT the last one? Can I do this without typing the name of all 49 columns? If so, then what if I want to exclude the last TWO columns? Thanks, John -- MySQL General Mailing List For list archives: http: