04.06.2015, 14:09
All of them are correct ways. I personally don't use ` character around fields' and table's name, nor ' around integers/floats so the query will be shorter.
About the INSERT query, you could add only the values and not the fields' name but if you use default values (something which you should do) add the names (only those with no default values).
About the INSERT query, you could add only the values and not the fields' name but if you use default values (something which you should do) add the names (only those with no default values).