SELECT *

A select list that asks for every column of the table, in the table's own order.

In more detail

It is the fastest way to meet a table at a shell. In application code it is a bad habit: the answer changes shape when someone adds a column, and it fetches large text and blob values nobody asked for. Name the columns instead.

Example

SELECT * FROM customers;

Related terms

Taught in

References