I'd like to select all columns in a table, but give only one of them an alias.
I have this table:
id base window thickness shading shape ... and many more columns
Now, I want to select the
base with an alias, like so:
SELECT base AS structure. But I want to select all the other fields as well, without having to type them all out.
SELECT *, base AS structure, but it gives me an error.
In truth, that's not even really what I want, because I don't want
base to show up at all.
Is this at all possible?
No, it isn't. Suck it up and type them all out :)