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