What SELECT * returns

Question

Accepted Answer

SELECT * returns every column in the order they appear in the table's CREATE TABLE definition. There is no sorting, no NULL filtering, and no extra columns. Avoid it in production queries - adding a new column later will silently change what your query returns.