Page MenuHomeDevCentral

Avoid use of SELECT * in queries
Open, LowPublic

Description

Best practices usually recommend to specify the exact fields, in the order we want it, instead of using SELECT *.

That help maintainability: if we remove a field from a table, but not in the code, it would be a silent error with SELECT * but a more visible SQL error with SELECT a, b, c

Event Timeline

dereckson created this task.