Never write SELECT * FROM


The database server has to resolve fields according to the schema. If you know the schema, it is highly recommended to name the fields.

Instead of:

SELECT * FROM clients


SELECT company_name, address, zip_code, telephone FROM clients
This best practice should only be applied if it is coherent with your project's specifications.
Under CC-By-NX-SA license