Hello,
I was wondering if it's possible to select all fields from a table except
certain columns, e.g.:
select * except text_name from text
I have found several discussions on and outside the MySQL mailing lists that
suggest it's not possible in (My)SQL. Why is this? It is a feature that would
be very useful in several cases, such as:
insert into text (select * except text_id, NULL as text_id from text)
select text.* except text_content, translatedText.text_content
from text, text as translatedText
where ...
It would be very nice to have this in MySQL.
With regards,
Mark van 't Zet
