Joseph Witchard;936490 wrote:
What if your query was getting a lot out, like:
How would it work when you pulled that much out?
If it really bothers you to take a minute to type out the column names, you could always do:
SELECT *, DATE_FORMAT(`date`, '%Y/%m/%d') AS `date_ymd` . . .
But really, it makes things clearer in your code if you go ahead and type out all the column names and also gets rid of any ambiguity as to what is being retrieved. Besides, it also may save some processing if you do not, in fact, actually need every column in that table). Never worry about saving time by avoiding a little typing now, when it might save you a lot of time later when debugging/updating the code later.