chris.cowart wrote:
> Lets say I have a table with fields 'Year', 'Make', and 'Model'.
> SELECT NOT(Year) FROM MyTable;
> If this worked, I would get a table with the columns 'Make' and 'Model'.
> Is there any way to do such a thing in MySQL
No.
> or would I have to explicitly list each column I want to select?
Explicitly listing each column you need is considered a good thing.
> I am interfacing MySQL from PHP, and I think it would be somewhat innefficient to explicitly list
> which columns I wanted as I would have to use PHP to query MySQL with 'DESCRIBE MyTable;',
> and then fetch each column name
Unless you are writing a generic MySQL frontend application (of which there are plenty already), you *know* the columns of your tables, so you just type them in.
--
felix
Please use
BBCode to format your messages in this forum.