Never write SELECT * FROM

(Development)

#57

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

write:

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

Go back