SELECT * and select All

The SELECT * and select all fields have the same effect on the query, and the speed is the same.

But in theory, select * will be quicker.

Because

1.select all fields consume more on data transfer, if the speed of hundreds of fields is not necessarily negligible.

2. The database query parses the query field before execution, and if it is a select * then this step is not required.

Note: For an ORM structure, general code instantiation is generally taken out of the field, when select * is slightly more maintainable, but the field name may be conflicting when select * Multiple table.

SELECT * and select All