Question · SQL and MySQL course · Module 2: Querying data (SELECT)

When to use the asterisk

When is it better in daily work to name specific columns instead of the asterisk *?

Answer options

  • Never - the asterisk is always best
  • Only when the table has a single column
  • When you look into an unknown shelf for the first time
  • When you need only a few fields - the result is clearer and faster
Show the answer

Correct answer:

  • When you need only a few fields - the result is clearer and faster