Hello,
I'm using PhpMyAdmin for the first time. A few questions:
Background:
I have the version of phpmyadmin with .php3 extensions. The site is being hosted on pair.com. Pair.com supports php4.
Question1:
When I run phpmyadmin it warns me that magic_quotes are not on, and that they need to be to run the program correctly. Since I do not have my own server how do I change this? Will it really be a problem if I leave them off?
Question2:
In creating my first table, I am using 8 fields. From what I understand they should all be indexed if I want to run a search on them later. Is that correct?
Question3:
Assuming they all have to be indexed, I know that the max index is 255, so on the varchars I am typing 20 in the "length/set" columns because I believe the values won't ever be bigger than 20. Is that the corrct approach?
Question4:
Under "attributes" what is the difference between binary, unsigned, and unsigned zerofill, and just leaving it blank? I have the year field as "unsigned zerofill" because I read that zerofill means that whatever is typed in the "length/set" column is definite (the year will always be 4.) All the other fields are blank.
Sorry for all the beginner questions, any help is greatly appreciated. Thanks,
Dan
I'm using PhpMyAdmin for the first time. A few questions:
Background:
I have the version of phpmyadmin with .php3 extensions. The site is being hosted on pair.com. Pair.com supports php4.
Question1:
When I run phpmyadmin it warns me that magic_quotes are not on, and that they need to be to run the program correctly. Since I do not have my own server how do I change this? Will it really be a problem if I leave them off?
Question2:
In creating my first table, I am using 8 fields. From what I understand they should all be indexed if I want to run a search on them later. Is that correct?
Question3:
Assuming they all have to be indexed, I know that the max index is 255, so on the varchars I am typing 20 in the "length/set" columns because I believe the values won't ever be bigger than 20. Is that the corrct approach?
Question4:
Under "attributes" what is the difference between binary, unsigned, and unsigned zerofill, and just leaving it blank? I have the year field as "unsigned zerofill" because I read that zerofill means that whatever is typed in the "length/set" column is definite (the year will always be 4.) All the other fields are blank.
Sorry for all the beginner questions, any help is greatly appreciated. Thanks,
Dan