SELECT * Except One Column in SQL: How To
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
Sometimes you want to select all columns from a table except for one or two.
If you write SELECT * you get every column. It's easy to write but hard to work with. And typing out all of the columns takes time.
In this video, I'll show you two methods in each database vendor that can make this process easier for you.
⏱ TIMESTAMPS:
00:00 - MySQL
03:00 - Postgres
04:11 - SQL Server
05:20 - Oracle
🔗 VIDEO LINKS:
Queries from this video: https://github.com/bbrumm/databasesta...
