Use column name instead of "*" in SELECT statement - Video

Normally when we use SELECT statements, Most of use simply using "*". The best practice says "Use the column list instead of *".

But, If the table has 50 columns then, It's very hard to enter all the column.

Is there any easiest way to use all the column names... Instead of typing or draging columns one by one ?

Yes. we have ...