4 ms·
> Never use SELECT * within the context of an application, as column additions or removals can break the app. To help with this problem, several databases now
by evanelias 5y ago
> Never use SELECT * within the context of an application, as column additions or removals can break the app.
To help with this problem, several databases now support a notion of "invisible columns", including Oracle, MySQL, and MariaDB. Invisible columns are excluded from SELECT *, but otherwise function like normal columns and can be queried explicitly by name.