MySQL SQL

MySQL SELECT

Retrieve rows and columns from a MySQL table.

Select columns

SELECT name, price
FROM products;

Use SELECT * to return every column, but listing required columns is clearer and reduces unnecessary data.