#1. For boolean fields I used tinyint(1) (0 being false and 1 being true). I use that for true/false. Is that the best field type to use?
#2. When calling up a SELECT query, if I only need for ex: customer,amount,gross fields from the database, should I define them or is using * (select all) ok?
ex: is it better to do it this way:
Code: Select all
SELECT customer,amount,gross FROM casesCode: Select all
SELECT * FROM cases