SELECT * with column-exclusion #1191
mbrouillet
started this conversation in
Ideas
Replies: 1 comment
-
Oh please yes, this would be a game changer! |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The following has been my Mysql dream evolution for many years. Warning: I'm talking about not being SQL syntax compliant.
Many times, I wish to SELECT all columns, except a few specific ones. For instance, if I
SELECT * FROM
a table that contains a description field with multiline text in some records, the table output gets cluttered with \n. I may not need that field for my current request. Other example is when having a binary field : aSELECT * FROM
is generally completely unusable. (I've resorted to never use binaries for this reason).My dream would be a syntax to list all-columns-except-a-few. For instance, this could be
SELECT *!column1!column2!column3 FROM...
or
SELECT *~column1~column2~column3 FROM...
Since
mycli
already has the list of columns for auto-completion, it seems feasible to pre-parse the query and replace the*!column1!column2!column3
by a list of all columns except the ones specified. Is this appealing to anyone ?Beta Was this translation helpful? Give feedback.
All reactions