search

ewaters / altsql-shell

An easily extensible DBI shell, perfect for a drop-in replacement to mysql-client
http://ewaters.github.com/altsql-shell
123 stars 19 forks source link

Select all columns except... #30

Open ewaters opened 12 years ago

ewaters commented 12 years ago

Sometimes it's nice to select * from table but omit one of the columns. To do this currently, you have to then explicitly list each column name. How about something like this:

select .all_except(picture) from staff;
select /* all except picture */ from staff;
select *.except(picture) from staff;
select * except picture from staff;