If I am not wrong, this is the best practice because of the following reasons:
It fetches only the required columns, reducing the amount of data transferred. By doing this, it also limits the possible exposure of sensitive data.
SQL keywords should be consistently capitalized to improve readability.
Maybe for this particular case, using '*' after the keyword 'SELECT' could lead to the same result, but I think it is good to develop the habit of just fetching the required columns by using their names and thus avoiding the possible fetching of unnecessary or sensible data.
I feel dump
I feel dump
If I am not wrong, this is the best practice because of the following reasons:
Maybe for this particular case, using '*' after the keyword 'SELECT' could lead to the same result, but I think it is good to develop the habit of just fetching the required columns by using their names and thus avoiding the possible fetching of unnecessary or sensible data.
Camillusfig,
Glad you found it useful. Happy coding!
Thanks!
This comment is hidden because it contains spoiler information about the solution
wow
This comment is hidden because it contains spoiler information about the solution
So you can create a list of comments?