Attributes has the options of binary, unsigned and unsigned zerofill. So I assume is signed by default? What's the difference between unsigned and unsigned zerofill?
Binary refers to text columns, its keeps the case sensitivity of the values so that in a search Item does not equal item.
Unsigned is to allow for negative numbers. A tinyint column unsigned allows for values from 0 -> 255. If signed its allows for values from -127 to 127.
Zerofill allows you to store 0 in AUTO_INCREMENT columns as 0 without generating a new sequence value.
What does setting Null or Not Null do?
Not null means the field must have a value. Any attempt to enter nothing into this field will throw an error. Null can allow for no value input into that field
Primary key is something I don't really understand, the more I read about it the less I understand it. Maybe I'm thinking to much about ID primary key in Access.
Pretty much the same thing.
Full text is about indexing a text field to allow sql searched for particular words stored inide that field without resorting to the like statement which is more intensive when doing a select....
jeex, i hope i got all this right....:p
