Reducing your productivity on a daily basis. (bcuz) wrote in mysql,
Reducing your productivity on a daily basis.

Simple question...

I basically taught myself programming so majority of times my code isn't as efficient as it could be.

my question is w/ sql statements... if i only need say 1 field from a table should i use

"select X FROM table"

or is

"select * from table" as efficient

i know common sense is pointing me to the first example but it never hurts to ask. also what happens if i need like 4 or 5 fields out of 10... would that be the same situation as if it were just 1 like the example above?
  • Post a new comment


    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.