MySQL SELECT * and List all the fields, which is more efficient?

MySQL SELECT * and List all the fields, which is more efficient

The answer is: how, it is not recommended to use SELECT * from

(1) SELECT * , the database is required to Query Table Metadata for Columns, to a certain extent, to increase the burden on the database.
But in fact, the efficiency difference is not small.

(2) Considering the future extensibility
Because the column you need to use in the program is determined after all, it SELECT * only reduces the length of a SQL String, and does not reduce the code elsewhere.

MySQL SELECT * and List all the fields, which is more efficient?